MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Vlookup


Posted by Teri on February 15, 2002 6:43 AM

I need a formula to lookup and match a column of codes (sheet1) to another column of codes (sheet2). Vlookup only looks up one value, I need the formula to look for a match to a column of 322 numeric codes and return a name for the codes supplied on sheet 2.

P.S. how do I send a little sample of the worksheet?


Posted by DrDrew on February 15, 2002 7:00 AM

This will do a lookup and return a value to be matched on sheet 2. Hope this helps a little.

=MATCH(VLOOKUP(A1,B1:B3,1),Sheet2!B1:B3)