+ Reply to Thread
Results 1 to 2 of 2

How to pull in data from multiple columns if entry matches cell from other sheet

  1. #1
    Registered User
    Join Date
    03-16-2021
    Location
    Pennsylvania
    MS-Off Ver
    2102
    Posts
    8

    How to pull in data from multiple columns if entry matches cell from other sheet

    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.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,210

    Re: How to pull in data from multiple columns if entry matches cell from other sheet

    In I2

    =VLOOKUP($A2,LOCATIONS!$A$2:$E$12,COLUMNS($A:B),FALSE)

    Copy across and down

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] need to pull data from another sheet that matches 2 criteria
    By allgoodthings in forum Excel General
    Replies: 2
    Last Post: 03-16-2021, 07:23 PM
  2. Replies: 1
    Last Post: 08-06-2019, 09:17 PM
  3. UserForm that Crosschecks Multiple Sheets to ensure Data Matches entry.
    By kreiner2006 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-06-2019, 01:12 PM
  4. Pull data from one sheet to another if a company name matches
    By toddbn in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-30-2015, 06:08 PM
  5. Pull data from multiple sheets based on cell in Main sheet
    By cpyter in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-29-2014, 01:19 PM
  6. Pull data from a specific sheet that matches cell value on Input Sheet
    By vaciaravino in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-12-2012, 08:38 PM
  7. [SOLVED] Multiple MATCHes required to pull correct (distinct) data
    By mmayna03 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-31-2012, 03:40 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1