Excel 2008 : Assign Vendor to Item Number

**DADADO** · 07-20-2012, 07:21 PM

I have several hundred product item numbers - each item number corresponds with a vender from whom I receive that item

Sheet 1:
In column A is a long list of item numbers - (Basically orders from customers listed by item number - so there are many duplicates but they are in alpha order - Column B is an item description - Column C is the quantity they have ordered - I would like column D to automatically insert the correct vendor to make purchasing much easier)

Sheet 2:
In column A there is all my vendor names - In column B is all of the corresponding item numbers they sell to me

Formula:
I would like a formula that will search column A of Sheet 1 and assign the corresponding vender in Column D of the same sheet - I only mention Sheet 2 because it will need to be referenced to get the corresponding vendor info

Is this possible - I have found similar issues in other threads but nothing that I could work with

Thx very much for taking the time to read my post

**xladept** · 07-20-2012, 07:56 PM

Yes, you can do that but I think you need to switch sheet2 so that the item numbers precede the vendor names, because the VLookUp can't go negative on the column (I read that somewhere).

Then you could use:

=VLOOKUP(A2,Sheet2!A2:B1500,2,0)

or something similar.