help Index/Match

[Perk]

I am trying to match up information from 2 spread sheet. I have pasted the information from 1 sheet into the 2nd. The information in column C & D needs to stay together, and then match column C with column B
I would like to add a column between columns B and C and have it display the information from column D that ties into the item in column B


UPC5.xlsx

[pixifaery]

Hi Perk

Insert a column and copy in the following formula into cell C2

Please Login or Register  to view this content.

There are some manufacturers without retailers which would return an error so the formula inserts blank ("")

Is this what you need?

P

[Perk]

Worked perfect. Thanks for the help