Forum Discussion

surfmunk's avatar
surfmunk
Copper Contributor
Dec 06, 2020

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

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....