Match & Merge columns

[TitleGB]

I have 4 columns (two have UPC's and two have prices) I need to match the two
UPC columns and merge identical UPC's into one column. But I want the prices
to remain in seperate columns so I can compare.

 

[Dave Peterson]

For this kind of thing, I do.

Start a new worksheet.
Copy the UPCs from both columns to a single column (one under the other).
Include a single row of headers.

The use data|Filter|advanced filter to get unique values from that single
column.
http://contextures.com/xladvfilter01.html#FilterUR
and
http://www.contextures.com/xlVideos04.html#AdvFilt2003
(Both from Debra Dalgleish's site)


Then I'd use a couple of =vlookup()'s (or =index(match())) functions to return
the values from each list.

Debra Dalgleish has lots of notes on =vlookup() and =index(match()) here:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))
and
http://contextures.com/xlFunctions02.html#Trouble