Forum Discussion
Vlookup
I have 2 spreadsheets that have 1 common field, Job #. I want to be able to lookup/match job # from 1 spreadsheet but pull in the cost data from spreadsheet 1 to spreadsheet 2.
Let's say job numbers are in A2:A100 and cost amounts in D2:D100 on the first sheet.
With a job number in B2 on the second sheet:
=IFERROR(VLOOKUP(B2, 'first sheet'!$A$2:$D$100, 4, FALSE), "")
Replace first sheet with the real name of that sheet. The number 4 specifies that the return value should be from the 4th column of the lookup range.
If you have Microsoft 365 or Office 2021:
=XLOOKUP(B2, 'first sheet'!$A$2:$A$100, 'first sheet'!$D$2:$D$100, "")
The formulas can be filled down.