Forum Discussion
Solved
Using a value in a cell as row reference
I am mirroring Cells from my datasheet to a second sheet. Is there a way to use the Value in A1 in the formula.
=Datasheet!A543. Is there a way to make "543" come from a reference cell.
I would like to be able to type the Row number I want to mirror in Cell A1 and have it update the row number in the Formula.
=Datasheet!A (and then #in Cell A1)
Thank you
RFGOfficeTC So the reference cell with the row number is A1. Then use this formula:
=INDIRECT("Datasheet!A"&A1)
2 Replies
RFGOfficeTC So the reference cell with the row number is A1. Then use this formula:
=INDIRECT("Datasheet!A"&A1)- This worked Perfectly. Thank you.
