tzippy
tzippy

Reputation: 6638

Google spreadsheet: use value as row number

I have a return value from a function in cell A1. Let's say it's 51. How can I use this value as a row number. I don't want 51 in A1 but instead I want the value from cell A51 in cell A1. Is there a formula?

Upvotes: 3

Views: 2760

Answers (1)

Max Makhrov
Max Makhrov

Reputation: 18707

Use indirect:

= indirect ("A"& 51)

Upvotes: 7

Related Questions