Feb 15 2022 06:23 AM
Hello.
I want to create a link between one cell in one sheet, to another cell in another sheet. At the same time, I want Excel to understand that the cell directly to the left and to the right are also to be linked to the other sheet. Lastly, I want this to happen when I write the excact name of the cell I'm referencing, not necessarily using "=".
It is kind of difficult to explain, so I've attached some screenshots. Does anyone know how to do this, if it even is possible?
Please help!
Feb 15 2022 06:30 AM
In A2 on Sheet X:
=XLOOKUP(B2, 'Sheet Y'!$B:$B, 'Sheet Y'!$A:$A, "")
In C2:
=XLOOKUP(B2, 'Sheet Y'!$B:$B, 'Sheet Y'!$C:$C, "")
You can fill this down as far as you want, even before entering data in column B on Sheet X.