How to referencing names on Sheet 1, column A on Sheet 2, row 4

%3CLINGO-SUB%20id%3D%22lingo-sub-1960819%22%20slang%3D%22en-US%22%3EHow%20to%20referencing%20names%20on%20Sheet%201%2C%20column%20A%20on%20Sheet%202%2C%20row%204%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1960819%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20list%20of%20names%20in%20Sheet%201%2C%20column%20A.%20On%20Sheet%202%2C%20I'd%20like%20to%20reference%20names%20in%20Sheet%201%20but%20in%20row%204.%20It%20is%20not%20a%20fixed%20set%20of%20names%20so%20I%20am%20not%20sure%20Transpose%20is%20the%20right%20path%20here.%20I'd%20like%20to%20be%20able%20to%20drag%20formula%20in%20Sheet%202%20across%20so%20as%20the%20list%20of%20names%20in%20Sheet%201%2C%20column%20A%20grows%2C%20it%20is%20referenced%20in%20row%204%2C%20column%20a%2C%20b%2C%20c%2C%20etc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYour%20assistance%20is%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1960819%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1960839%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20referencing%20names%20on%20Sheet%201%2C%20column%20A%20on%20Sheet%202%2C%20row%204%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1960839%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F892784%22%20target%3D%22_blank%22%3E%40surfmunk%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20shortcut%20is%20to%20create%20a%20named%20range%20and%20Transposing%20by%20selecting%20the%20row%20to%20make%20it%20a%20real-time%20update%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22adversi_0-1607291855090.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F238124iE3C299A806DCCDF5%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22adversi_0-1607291855090.png%22%20alt%3D%22adversi_0-1607291855090.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1960896%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20referencing%20names%20on%20Sheet%201%2C%20column%20A%20on%20Sheet%202%2C%20row%204%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1960896%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F867265%22%20target%3D%22_blank%22%3E%40adversi%3C%2FA%3EThank%20you%20very%20much.%20That%20was%20super%20helpful.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi,

 

I have a list of names in Sheet 1, column A. On Sheet 2, I'd like to reference names in Sheet 1 but in row 4. It is not a fixed set of names so I am not sure Transpose is the right path here. I'd like to be able to drag formula in Sheet 2 across so as the list of names in Sheet 1, column A grows, it is referenced in row 4, column a, b, c, etc.

 

Your assistance is appreciated.

2 Replies

@surfmunk 

The shortcut is to create a named range and Transposing by selecting the row to make it a real-time update:

adversi_0-1607291855090.png

@adversiThank you very much. That was super helpful.