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
