Reputation: 131
E.g
Cell M25
has the value 10:
=Init_Data!K CELL(M25)
would say:
=Init_Data!K10
I've Googled hard for this but it's such a weird one to explain.
Thanks
Upvotes: 0
Views: 51
Reputation: 152535
INDIRECT is Volaitle and in this instance you can use INDEX instead which is not:
=INDEX(Init_Data!$K:$K,M25)
Upvotes: 1