Forum Discussion
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 =[Tango.xlsx]Alfa!A1 fine,
but I'm wanting to reference the workbook Tango (in cell B3) and the workbook Alfa (in cell B5)
I was thinking it would look something like this =[B3]B5!A1 but I can't get it to work.
any suggestions?
Obviously once I get the principle working my formulas will get more complicated but I need to get this referencing right first.
- wow, thanks, that works. thank you so much (I spent all day yesterday trying to work this out for myself) thank you
TimEnt006 I have the same issue. I am having better solutions with INDEX, but still not live. I need to have manually written the whole address to the workbook tab, and then I can by formula select a cell. But it would be more workable if I could also make as formula the filename, address, and workbook too.
- wow, thanks, that works. thank you so much (I spent all day yesterday trying to work this out for myself) thank you
