Trying to combine 2 Worksheets

[kiwibobz]

Hi,
I am stumped.
In Excel 2007, I am trying to combine 2 reasonably large worksheets
(thousands of columns) into a seperate third worksheet by comparing the 2
worksheets by say the first Column or "key" of each (lets call it Product
Code) which is found on both spreadsheets.
The first spreadsheet is my "master" and original spreadsheet containing all
the important product codes.
The second spreadsheet contains updating pricing for those specific "Product
Codes" plus a whole lot more rows/ or "Product codes" that I do not use.

What I want to do is take the first spreadsheet "Product codes" and compare
and combine the same "Product codes" from the newer spreadsheet - into the
brand new created sheet (so that importantly the prices from the original
sheet are updated) - and are shows as a single row/ or line on the new sheet.

I am pretty sure this can be done somehow with some formula or feature in
Excel, but are not sure how to do it! I have even tried the new
"Consolidate" Button feature of Excel, but this does not seem to work either
and no luck trying to use the normal help files..

Any help would be appreciated

thanks

Bob

 

[Dave Peterson]

I'm not sure why you'd need that 3rd worksheet.

I'd insert a couple of columns near the existing price column.

Then I'd use either =vlookup() or =index(match()) to retrieve the newer price
from the other worksheet in one of those columns.

And I'd use the second new column as an indicator:

=if(b2=c2,"Same","different")

Then I could filter by this column to find and review the differences.

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