Looking up data on separate sheets

Contributor

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?

1 Reply

@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.