Excel linking and referencing between sheets

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3167747%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EExcel%20linking%20and%20referencing%20between%20sheets%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3167747%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EHello.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EI%20want%20to%20create%20a%20link%20between%20one%20cell%20in%20one%20sheet%2C%20to%20another%20cell%20in%20another%20sheet.%20At%20the%20same%20time%2C%20I%20want%20Excel%20to%20understand%20that%20the%20cell%20directly%20to%20the%20left%20and%20to%20the%20right%20are%20also%20to%20be%20linked%20to%20the%20other%20sheet.%20Lastly%2C%20I%20want%20this%20to%20happen%20when%20I%20write%20the%20excact%20name%20of%20the%20cell%20I'm%20referencing%2C%20not%20necessarily%20using%20%22%3D%22.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EIt%20is%20kind%20of%20difficult%20to%20explain%2C%20so%20I've%20attached%20some%20screenshots.%20Does%20anyone%20know%20how%20to%20do%20this%2C%20if%20it%20even%20is%20possible%3F%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EPlease%20help!%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-display-wrapper%22%20lia-image-align-inline%3D%22%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fgxcuf89792%2F%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F348353i5E185E1DD045C1A4%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22Sheet%20X.PNG%22%20x.png%3D%22%22%20alt%3D%22Sheet%20X%22%20%2F%3E%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-caption%5C%26quot%3B%22%20onclick%3D%22%5C%26quot%3Bevent.preventDefault()%3B%5C%26quot%3B%22%3ESheet%20X%26lt%3B%5C%2Fspan%26gt%3B%26lt%3B%5C%2Fspan%26gt%3B%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-display-wrapper%22%20lia-image-align-inline%3D%22%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fgxcuf89792%2F%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F348354iDF2C3999BD4E45B4%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22Sheet%20Y.PNG%22%20y.png%3D%22%22%20alt%3D%22Sheet%20Y%22%20%2F%3E%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-caption%5C%26quot%3B%22%20onclick%3D%22%5C%26quot%3Bevent.preventDefault()%3B%5C%26quot%3B%22%3ESheet%20Y%26lt%3B%5C%2Fspan%26gt%3B%26lt%3B%5C%2Fspan%26gt%3B%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3167747%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EOffice%20365%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3167747%22%20slang%3D%22en-US%22%3EExcel%20linking%20and%20referencing%20between%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3167747%22%20slang%3D%22en-US%22%3E%3CP%3EHello.%3C%2FP%3E%3CP%3EI%20want%20to%20create%20a%20link%20between%20one%20cell%20in%20one%20sheet%2C%20to%20another%20cell%20in%20another%20sheet.%20At%20the%20same%20time%2C%20I%20want%20Excel%20to%20understand%20that%20the%20cell%20directly%20to%20the%20left%20and%20to%20the%20right%20are%20also%20to%20be%20linked%20to%20the%20other%20sheet.%20Lastly%2C%20I%20want%20this%20to%20happen%20when%20I%20write%20the%20excact%20name%20of%20the%20cell%20I'm%20referencing%2C%20not%20necessarily%20using%20%22%3D%22.%3C%2FP%3E%3CP%3EIt%20is%20kind%20of%20difficult%20to%20explain%2C%20so%20I've%20attached%20some%20screenshots.%20Does%20anyone%20know%20how%20to%20do%20this%2C%20if%20it%20even%20is%20possible%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Sheet%20X%22%20style%3D%22width%3A%20928px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F348353i5E185E1DD045C1A4%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Sheet%20X.PNG%22%20alt%3D%22Sheet%20X%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3ESheet%20X%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Sheet%20Y%22%20style%3D%22width%3A%20869px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F348354iDF2C3999BD4E45B4%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Sheet%20Y.PNG%22%20alt%3D%22Sheet%20Y%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3ESheet%20Y%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3167747%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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!

 

Sheet XSheet XSheet YSheet Y

1 Reply

@jonasch 

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.