Hey Everybody,
Long time reader, first time poster.
I am trying to write a formula to lookup multiple vendor SKU numbers after a UPC is given. I want to scan a barcode on a product and have excel look through an ODBC data set for that UPC, and then give me the corresponding vendors SKU. In my system, one vendor is assigned vendor number 66 the other is vendor number 499. Each vendor has their own SKU for the same exact product with the same UPC. Currently I have to scan these barcodes in 2 different spots to get each vendors SKU. I have included screenshots of the built table and my data set. My idea is that I want excel to search for the UPC in column A, then look over in column I to see if the vendor number is 66 or 499, then return the data in column J based on what it finds in column I.
I have tried several formulas to make this work, this one returns the correct SKU for vendor 66 in cell B2
=IF(Data!I:I=66,(INDEX(Data!J:J,MATCH(A2,Data!A:A,0))))
But when I copied the above formula to B3 and changed the vendor number to 499 (exact formula below) it give a reading of FALSE.
=IF(Data!I:I=499,(INDEX(Data!J:J,MATCH(A2,Data!A:A,0))))
I am completely out of ideas, cannot think of anything else to try.
Bookmarks