Forum Discussion
Extract cell value using navigation
If I had keyed in '5" in A1, and in A5, I keyed in =A1, A5 shows 5. If C10=15, how do I formulised A5 to extract out 15 from C10 using A1? So, it means , moving 2 cell to the right from A1 and then moving 9 cells downward.
2 Replies
Chan_Tze_Leong I have no idea how a 5 in A1 means move right 2 and down 9 but the function you are looking for is probably OFFSET as in:
=OFFSET(A1,9,2)
