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

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

=VLOOKUP(D1,$K$1:$L$150,2)

Celia

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

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