Forum Discussion
Filling source cells from destination
I am looking to create a spreadsheet that will pull info from a source workbook or sheet and apply it to a destination workbook or sheet (whichever is easier). I want to be able to input a part numbe...
Let's say the source sheet is named exactly that: Source Sheet.
The data on this sheet are in rows 2 through 200 (with headers in row 1).
In cell C2 on the destination sheet, enter the following formula if you have Microsoft 365 or Office 2021:
=XLOOKUP(B2, 'Source Sheet'!$C$2:$C$200, 'Source Sheet'!$F$2:$F$200, "")
If you have an older version:
=IFERROR(VLOOKUP(B2, 'Source Sheet'!$C$2:$F$200, 4, FALSE), "")
Fill down as far as you want.