Using vlookup

[Guest]

How do you look up Name by using VLOOKUP, thru another worksheet.

 

[L. Howard Kittle]

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