Consolidating Data AND Text Fields

  • Thread starter Thread starter drmike29
  • Start date Start date
D

drmike29

I am familiar with using the Excel CONSOLIDATE function to SUM data of
several spreadsheets, but I need to carry-over information contained in
several TEXT columns (other than the left-most column). The spreadsheets
being consolidated do not contain identical columns, but some of the
non-matching columns contain unique data that needs to be part of the
consolidated sheet.

Any help would be greatly appreciated. I am trying to produce something
similar to the below. Please advise.
Mike

Sheet 1

A B C D E
Joe Atlanta 3 5
Pete Boston 2 4
Ralph Texas 4 5

Sheet 2

A B C D E
Joe 4 2 Fair
Jim 3 3 Good
Pete 3 1 Fair
Ralph 2 6 Excellent

Consolidated Sheet

A B C D E
Joe Atlanta 7 7 Fair
Jim 3 3 Good
Pete Boston 5 5 Fair
Ralph Texas 6 11 Excellent
 
The VLOOKUP function can return text values. For example, on the Summary
sheet, in cell A2:

=VLOOKUP(A2,Sheet1!$A$2:$B$50,2,0)

Or, to hide the #N/A error for missing cities:

=IF(ISNA(VLOOKUP(A2,Sheet1!$A$2:$B$50,2,0)),"",VLOOKUP(A2,Sheet1!$A$2:$B$50,2,0))
 
Back
Top