How to get column value in Excel based on other value results?-CodePudding

I need to get value based on other value result.

For example: column A1 returns 24, so I need to get value from A24.

It should be simple but I can't find how to do it!

Thanks in advance for your help!

CodePudding user response：

Assuming you want hard-coded column A with a variable row based on the value of cell A1, you would end up with a formula that says: =INDIRECT(CONCAT("A", A1))

CodePudding user response：

INDIRECT is a volatile function, so to be avoided where possible. Simply:

=INDEX(A:A,A1)