Ms.

I have this data:

I1_ABRVND I1_ITEM I1_VNDMODEL I1_VENDOR VN_VNDNAME AD Vendor Name AD Vendor Number
AO HW399 HW399 SMR Z38 125# 227 AO SMITH WATER PRODUCT CO A. O. Smith 6933
AO 100111050 100111050 68000 AO SMITH WATER PRODUCT CO A. O. Smith 6933
AO 100111024 100111024 68000 AO SMITH WATER PRODUCT CO A. O. Smith 6933
AO 100111041 100111041 68000 AO SMITH WATER PRODUCT CO A. O. Smith 6933
AO 100111040 100111040 68000 AO SMITH WATER PRODUCT CO A. O. Smith 6933

 

and I have this data:

ITEM_ID PART_NUMBER MANUFACTURER_PART_NUMBER UPC MANUFACTURER_NAME MANUFACTURER_ID BRAND_NAME BRAND_ID
4071328 PLBG_Item_197043 DEL-40   A. O. Smith 6933 AO Smith® 11376
4071329 PLBG_Item_124210 DEL-401515120   A. O. Smith 6933 AO Smith® 11376
4071330 PLBG_Item_124211 DEL-401515208   A. O. Smith 6933 AO Smith® 11376
4071331 PLBG_Item_124212 DEL-401515240   A. O. Smith 6933 AO Smith® 11376
4071332 PLBG_Item_124213 DEL-402020120   A. O. Smith 6933 AO Smith® 11376
4071333 PLBG_Item_124214 DEL-402020208   A. O. Smith 6933 AO Smith® 11376
4071334 PLBG_Item_124215 DEL-402020240   A. O. Smith 6933 AO Smith® 11376

 

I want to do a vlookup on I1_ITEM but I also want to verify that the manufacturer is the same, as I have over 600 mfg, and I1_ITEM can be used by multiple manufacturers. Is there anyway to do a vlookup with an IF or MATCH embedded to look at the 

MANUFACTURER_ID 

 and the MANUFACTURER_PART_NUMBER

 

matched against I1_ITEM and AD Vendor Number in the first table?

 

Right now I’m just creating new sheets for each vendor number and copying data from second table and doing vlookup from that, but this is very time consuming.

 

 

 

 

 

By: Marlise

Leave a Reply

Your email address will not be published. Required fields are marked *