Follow

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use
Contact

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!

MEDevel.com: Open-source for Healthcare and Education

Collecting and validating open-source software for healthcare, education, enterprise, development, medical imaging, medical records, and digital pathology.

Visit Medevel

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

Add a comment

Leave a Reply

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use

Discover more from Dev solutions

Subscribe now to keep reading and get access to the full archive.

Continue reading