Hi there,
I'm looking for a formula to link back a tab from separate file (file stays the same) but the tab name will be the changing parameter set on what is in cell A1.
So for instance:
In a file "Z" cell A1=YOY (that's my tab name)
Therefore, I would like to link what's in a cell D1 of "X" file in tab YOY back to document "Z".
So, If I change A1 to YTD, the formula will look for a cell D1 of "X" file in tab YTD and link back to document "Z".
I guess it's based on indirect function. But any idea how to incorporate it?
I'm looking for a formula to link back a tab from separate file (file stays the same) but the tab name will be the changing parameter set on what is in cell A1.
So for instance:
In a file "Z" cell A1=YOY (that's my tab name)
Therefore, I would like to link what's in a cell D1 of "X" file in tab YOY back to document "Z".
So, If I change A1 to YTD, the formula will look for a cell D1 of "X" file in tab YTD and link back to document "Z".
I guess it's based on indirect function. But any idea how to incorporate it?
