Forum Discussion

M4rk-B's avatar
M4rk-B
Copper Contributor
Feb 27, 2021

Can I include the text in another cell to identify a data source ?

Hello all,  Bit of a left field request.  I have a database with several sheets and want the user to be able to compare data in two of them.  To get the cell A1 data from the second sheet, I'd nor...
excel
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Feb 27, 2021

M4rk-B 

That could be

=INDIRECT("'" & B1 & "'!A1")

or

=INDIRECT("'" & B1 & "'!" & ADDRESS(ROW(A1),COLUMN(A1)))

 to make it more dynamic.

  • M4rk-B's avatar
    M4rk-B
    Copper Contributor
    Mar 01, 2021
    Thanks Sergei, that was spot on.