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


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


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.