Slopax
Slopax

Reputation: 131

Google Sheet / Excel - Use formula as the cell row for parent formula?

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

Answers (2)

Scott Craner
Scott Craner

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

TheMaster
TheMaster

Reputation: 50555

=INDIRECT ("Init_Data!K"&M25)

Upvotes: 1

Related Questions