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.
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.Yet another option: using INDEX.
- Thanks for this option without the " " quotes. Appreciate your help.
Here's an alternative. INDIRECT is one way, as has been shown.
I would choose to use VLOOKUP.. As with the other response, you can enter a row number here (which doubles as an account number on your "Account Details" sheet), entering it in cell F1.
I only did the first 11 rows on "Bin Cards" figuring you can do the rest following the example.
- Thanks! I was having a hard time getting the syntax just right. Appreciate your help.
