Forum Discussion
Excel cell reference
Q-Actually I have a list of numbers from A1 to A100. Out of this list I want to choose the numbers say from A20 onwards. But this need to be done through formula. Like, I have 'A' written in Say C...
Hi Naveen,
This is the formula:
=INDIRECT(C1 & D1)
Regards
Or:
=INDEX(A:A;D1)
- Thank you very much
