I need to get value based on other value result, for example: columm A1 return 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 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)