Forum Discussion

RFGOfficeTC's avatar
RFGOfficeTC
Copper Contributor
Nov 17, 2023
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 li...
excel
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Nov 17, 2023

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

     

    =INDIRECT("Datasheet!A"&A1)

     

     

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Nov 17, 2023

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

 

=INDIRECT("Datasheet!A"&A1)

 

 

  • RFGOfficeTC's avatar
    RFGOfficeTC
    Copper Contributor
    Nov 17, 2023
    This worked Perfectly. Thank you.

Resources