Equivalent of vlookup in MS Word

[yabi100]

I have a table in Excel with one column named employee ID Number.
I have a table in MS Word.
I want to enter employee ID Number in MS Word table and all other relevant columns populated from Excel table.
Is it possible?
If not, what other method do you recommend?

 

[BadgerRoad]

Have you considered the mailmerge feature in Word?

 

[yabi100]

Have you considered the mail merge feature in Word?

I haven't used it. Does it offer the function, I am looking for?

 

[BadgerRoad]

It probably doesn't do exactly what you want, but you might be able to make it work. You can use Excel as the data source for a Word Mail Merge. You would need to then format your Word table like a label. The Mail Merge would then pull all the data from Excel for all Employee IDs.
That may not be exactly what you are looking for but it's a possibility. If this looks promising there are YouTube videos on how to use Excel as a data source. I can provide a link if you are interested.

 

[yabi100]

It probably doesn't do exactly what you want, but you might be able to make it work. You can use Excel as the data source for a Word Mail Merge. You would need to then format your Word table like a label. The Mail Merge would then pull all the data from Excel for all Employee IDs.
That may not be exactly what you are looking for but it's a possibility. If this looks promising there are YouTube videos on how to use Excel as a data source. I can provide a link if you are interested.

Thanks a lot. I can't watch youtube videos from Iran. I find useful links from Microsoft site for mail merge. Let me try them and I will write about my progress.