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)