Formula needed for shifting values between columns. How can I achieve this?

Hello,

Below I have provided a sample of my data from a much larger dataset. I would like to put the values that are in the green box (under headings X and Y) in the cells of the orange box based on the values in the FID columns. In the orange box I have provided some results that I have manually inserted myself (refer to the green box as to where I derived my results). I hope you can interpret what I am trying to achieve. The issue is that the values of 'FID' under column P have duplicates, whereas the FID under column 'B' does not. Thank you!

Update: I need to use the VLOOKUP function, but I have no idea how to use this function. Can anybody help with this? Thank you.

Hi Ben,

Please don't PM users asking for help as it's against forum rules (refer Rule 8 here). Thanks.

The following VLOOKUP formulas should suffice as that function will stop after it finds the first match which doesn't seem to be an issue here as the Y and X values are the same for each FID:

Cell I2: =IFERROR(VLOOKUP($B2,$P:$R,2,FALSE),0)
Cell J2: =IFERROR(VLOOKUP($B2,$P:$R,3,FALSE),0)

Copy these formulas down as far as required (Row 15 in your posted example).

Regards,

Robert

Thanks for letting us know and you're welcome. Thanks also for marking the thread as solved and the rep