ExcelBanter - Using vlookup

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Using vlookup (https://www.excelbanter.com/excel-discussion-misc-queries/30856-using-vlookup.html)

Cindy

Using vlookup

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

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

All times are GMT +1. The time now is 12:47 PM.