I have contact information from various sources listed in the same Excel workbook, but on different sheets.
I want to create a summary sheet that combines certain common fields from all of the various sheets.
For instance, on the sheet titled "Combined", I have a column named "Salutation".
I want to pull the "Salutation" data from "Sheet 1", "Sheet 2", "Sheet 3" and "Sheet 4" into the Salutation column on the "Combined" sheet.
In the various other columns on the "Combined" sheet, I'll want to do similar with fields like "Addressee", "City", "State", "ZIP".
I have successfully used INDEX / MATCH to pull data from "Sheet 1" like this:
=INDEX('Sheet 1'!A2:ZZ20,0,MATCH("Salutation",'Sheet 1'!A1:ZZ1,0))
But... that pulls only from "Sheet 1".
How can I pull also from "Sheet 2", "Sheet 3", and "Sheet 4" into that same column?
I want to create a summary sheet that combines certain common fields from all of the various sheets.
For instance, on the sheet titled "Combined", I have a column named "Salutation".
I want to pull the "Salutation" data from "Sheet 1", "Sheet 2", "Sheet 3" and "Sheet 4" into the Salutation column on the "Combined" sheet.
In the various other columns on the "Combined" sheet, I'll want to do similar with fields like "Addressee", "City", "State", "ZIP".
I have successfully used INDEX / MATCH to pull data from "Sheet 1" like this:
=INDEX('Sheet 1'!A2:ZZ20,0,MATCH("Salutation",'Sheet 1'!A1:ZZ1,0))
But... that pulls only from "Sheet 1".
How can I pull also from "Sheet 2", "Sheet 3", and "Sheet 4" into that same column?