Moving data

[Skeet]

I would like to make a list of menu items in one place and then a list of
people in another. Next to each persons name I would like to enter the menu
number and have the menu idea appear in that cell. Can Excel did this?
Thanks for the help.

 

[Don Guillett]

have a look in help index for vlookup