Lookup Help

jpr1877

New Member
Joined
Jan 11, 2005
Messages
6
Hey guys--

Alright, here's my problem. I have two sheets. Sheet1 is a listing of part numbers in Column A and part descriptions in Column B. In Sheet2, I have in Column A a bulk list of part numbers from orders, and many of the part numbers are in there more than once. In Column B, I would like to match the part descriptions from Sheet1 Column B. Isn't there a Lookup or Match function that will allow me to do this? I've looked and I've played, but I can't seem to come across the correct answer.

Thanks,

Desperate in Dallas
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

NBVC

Well-known Member
Joined
Aug 31, 2005
Messages
5,828
Try in column B of sheet 2.

=Vlookup(A1,Sheet1!$A$1:$B$100,2,0)

Adjust the range to suit the size of the range in Sheet 1, then copy down the formula.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,731
Messages
5,573,880
Members
412,555
Latest member
mark84
Top