Extract cell value using navigation

%3CLINGO-SUB%20id%3D%22lingo-sub-2136508%22%20slang%3D%22en-US%22%3EExtract%20cell%20value%20using%20navigation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2136508%22%20slang%3D%22en-US%22%3E%3CP%3EIf%20I%20had%20keyed%20in%20'5%22%20in%20A1%2C%20and%20in%20A5%2C%20I%20keyed%20in%20%3DA1%2C%20A5%20shows%205.%20If%20C10%3D15%2C%20how%20do%20I%20formulised%20A5%20to%20extract%20out%2015%20from%20C10%20using%20A1%3F%20So%2C%20it%20means%20%2C%20moving%202%20cell%20to%20the%20right%20from%20A1%20and%20then%20moving%209%20cells%20downward.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2136508%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional 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)