how to get colum value in excel based on other value results?

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!

>Solution :

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))

Leave a Reply