If a word in a range then check the left word of this word

[frankrss]

Hi, I would like to use Macro to check a word whether it is in a range, if it is in a range, then to check the left word of this word.
For example:

The range in Excel is:

Name	Age
Ingrid	30
Peter	20
Hans	18
Jan	35

<tbody>
</tbody>

The texts in my MS Word are :
45 Jan, 30 Ingrid 18 Hans and 30 Peter.
How can I use Macro in Word to Check the range in Excel whether the age is correct or not?

In this example the age of Jan and Peter are not right. Because Jan is 35 and Peter is 20.

Thanks
Frank

 

[FDibbins]

Is this an Excel or a Word question? (you posted in excel)

 

[frankrss]

Yes, the range is in Excel. But the texts are in Word.

 

[jimrward]

How many names are in your lookup list with the correct data currently in your excel range

 

[frankrss]

I am not sure now. suppose 500.

 

[frankrss]

My logica is;

1. First it will check the words in MS word (a loop), if a word is in the list of Excel (mabye via Array), it will find the left word of it and it will use VLookup to see whether the left word is the same as in Excel.
2. If it is not the same it will pop up a message to let the user to replace it or not.

 

[jimrward]

500 unique names and ages ?? Or is this the number of names in your word document, what happens when you have two peters with different ages in your excel list

 

[frankrss]

Yes. The names in the Excel are unique.