Hi Cindy,

If I understand correctly something like this perhaps.

=VLOOKUP(B1,Sheet2!A1:B4,2,0)

Where B1 is on sheet 1 and the lookup array A1:B4 is on sheet two.

HTH
Regards,
Howard

"Cindy" wrote in message
...
How do you look up Name by using VLOOKUP, thru another worksheet.