MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Vendor numbers and part numbers

Posted by Al Polan on May 27, 2000 12:47 PM

I have 550 vendor numbers in column D with many duplicates, I also have 150 of these numbers in numerical order in column K with my corresponding part next to them in column L. How do I match the numbers in column D with those in column K and have my corresponding part numbers in column L appear in column E next to it's correct vendor number?
Ihope someone can help with this. I am using windows 98 and Excel 2000

Posted by Celia on May 27, 2000 4:01 PM

Have a look at the VLOOKUP worksheet function (in Help).
Try putting the following formula in E1 and drag it down :-



Posted by Al Polan on May 28, 2000 9:40 AM

Celia, thank you so much, it works perfectly. Al