Forum Discussion
Solved
Referencing a Row Number
I am trying to use the text data entered on Sheet 1 and re-use it as text in Sheet2. Text in Sheet1, Row 2 is rearranged to a nice formatted display on Sheet 2. I can do this by entering ='Shee...
See the attached version. The row number is entered in F1 (you can move it of course) and the formulas use INDIRECT to refer to the value of F1 as row number.
Thank you so much! This has been driving me crazy. I didn't get the syntax right when I tried it.
Thanks again.
Thanks again.
Yet another option: using INDEX.
- Thanks for this option without the " " quotes. Appreciate your help.