Index/Match

[drummerbum]

Sheet 1:

Please Login or Register  to view this content.

Sheet 2:

Please Login or Register  to view this content.

I have a macro that automatically pulls all of our active UPC's (UPC1, UPC2, UPC3) from sheet 2 and compiles them into the UPC column in sheet 1. What I need to do is search UPC1, UPC2, and UPC3 on sheet 2 for the UPC value on sheet 1, and return the coresponding Type value back to Sheet 1.

I need sheet 1 to look like:

Please Login or Register  to view this content.

I'm fairly certain Index/Match will do the trick...but I haven't been able to figure it out all day~

[ConneXionLost]

If you're only dealing with Small, Medium, and Large, then how about:

Please Login or Register  to view this content.

Cheers,