SOLVED

# Using a value in a cell as row reference

Copper Contributor

# 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

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

# Re: Using a value in a cell as row reference

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

``=INDIRECT("Datasheet!A"&A1)``

# Re: Using a value in a cell as row reference

This worked Perfectly. Thank you.
1 best response

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

# Re: Using a value in a cell as row reference

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

``=INDIRECT("Datasheet!A"&A1)``