MrExcel Publishing
Your One Stop for Excel Tips & Solutions


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.