Forum Discussion
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
='Sheet1'!B2 and as needed for other fields. Using this for data in A2, B2, C2, D2, E2, F2.
I am using CONCATENATE to put text strings together in some cells.
I would like to have a Cell that I can put a number in, and that number represents the Row Number in Sheet 1. For Example - put a 4 in the Cell & then the Sheet 2 fields use data from Row 4 on Sheet1.
='Sheet1'!B2 and as needed for other fields. Using this for data in A2, B2, C2, D2, E2, F2.
Enter Number 4 and all the data matches basically becomes
='Sheet1'!B4 and uses data from A4, B4, C4, D4, E4, F4.
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.
6 Replies
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.
- MikeD760Copper ContributorThank you so much! This has been driving me crazy. I didn't get the syntax right when I tried it.
Thanks again.