Apr 13 2022 11:49 AM
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?
Apr 13 2022 12:06 PM
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.