In the attached spreadsheet, I'm looking to pull the locations (City, State, Zip Code, Country) from the second sheet called, "LOCATIONS," into the first sheet labeled "SHEET1."
The city, state, zip code, and country for each household should match the location listed on the other sheet. In other words, the PujolsAlbertHousehold should have the correct city, state, zip code, and country pulled in from the LOCATIONS sheet and entered into row 2 on Sheet1.
I'm expecting to enter the formula in Sheet1 cell I2 and then drag it down to I12.
Bookmarks