SOLVED

Using a value in a cell as row reference

Copper Contributor

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

 

 

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

@RFGOfficeTC So the reference cell with the row number is A1. Then use this formula:

 

=INDIRECT("Datasheet!A"&A1)

 

 

This worked Perfectly. Thank you.
1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

@RFGOfficeTC So the reference cell with the row number is A1. Then use this formula:

 

=INDIRECT("Datasheet!A"&A1)

 

 

View solution in original post