Extract cell value using navigation

Brass Contributor

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

 

=OFFSET(A1,9,2)

@Chan_Tze_Leong 

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