Forum Discussion

erin-5304's avatar
erin-5304
Brass Contributor
Apr 13, 2022

Looking up data on separate sheets

First sheet:  List of company names and addresses.  Name | Address | City, St, Zip (separate columns)

Second Sheet: Invoice with company name on it: (different rows)

Company name

Address

City, St, Zip

 

I would like to pull the information from the first sheet using the company name on the second sheet and have the address auto fill in separate cells on sheet 2.  Is there a formula for this?

excel
Formulas and Functions

1 Reply

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Apr 13, 2022

    erin-5304 

    Let's say you have company name in A2 on the second sheet.

    For the address:

    =IFERROR(VLOOKUP(A2, 'First Sheet'!$A$2:$C$1000, 2, FALSE), "")

    For city/state/zip:

    =IFERROR(VLOOKUP(A2, 'First Sheet'!$A$2:$C$1000, 3, FALSE), "")

    These formulas can be filled down.

Resources