Filling source cells from destination

Copper Contributor

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 number into a cell in column B (on destination) and have a formula that will query the source looking for that part number (column C) and the price (column F). I would then need the price to be brought back to the destination file and inserted into the same row but in column C. Is there any way to do this or am I trying to do the impossible?

1 Reply


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.