Forum Discussion

TimEnt006's avatar
TimEnt006
Copper Contributor
Jan 12, 2023
Solved

external reference designated by cell value

I'm wanting to link to cells to a different workbook where the workbook name and worksheet name are designated by cell values.   i.e. =A1 in workbook "Tango" and work sheet "Alfa" So this works  =...
excel
Formulas and Functions
  • TimEnt006's avatar
    TimEnt006
    Jan 12, 2023
    wow, thanks, that works. thank you so much (I spent all day yesterday trying to work this out for myself) thank you
Harun24HR's avatar
Harun24HR
Bronze Contributor
Jan 12, 2023

TimEnt006 You need INDIRECT() function.

 

=INDIRECT("["&B3&"]"&B5&"!A1")

 

 

TimEnt006's avatar
TimEnt006
Copper Contributor
Jan 12, 2023
wow, thanks, that works. thank you so much (I spent all day yesterday trying to work this out for myself) thank you

Resources