Excel cell value from address

%3CLINGO-SUB%20id%3D%22lingo-sub-3422922%22%20slang%3D%22en-US%22%3EExcel%20cell%20value%20from%20address%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3422922%22%20slang%3D%22en-US%22%3E%3CP%3EI%20know%20I'm%20doing%20something%20dumb.%20I%20have%20a%20vector%20of%20row%20numbers.%20I%20can%20use%20them%20and%20column%20numbers%20in%20the%20ADDRESS%20function%20to%20return%20Excell%20addresses%20containing%20a%20number%20I%20want%20to%20get%2C%20e.g.%2C%20ADDRESS(P4%2C13)%20returns%20%24M%24722.%26nbsp%3B%20(P4%20is%20the%20cell%20that%20contains%20the%20number%20722%2C%20in%20the%20vector%20of%20row%20numbers.)%26nbsp%3B%20What%20I%20really%20want%20is%20the%20number%2Fcontents%20in%20cell%20%24M%24722.%26nbsp%3B%20I%20can%20figure%20out%20how%20to%20take%20the%20cell%20address%20to%20return%20the%20number.%26nbsp%3B%20It%20seems%20like%20the%20%24M%24722%20is%20acting%20like%20it%20is%20text.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3422922%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3422988%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20cell%20value%20from%20address%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3422988%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1400148%22%20target%3D%22_blank%22%3E%40Norm_Dotti%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DINDIRECT(ADDRESS(P4%2C13))%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EYou%20can%20try%20this%20formula%20which%20works%20in%20my%20sheet.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22address.JPG%22%20style%3D%22width%3A%20923px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F374746iC0A5EE6A0DFE3D05%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22address.JPG%22%20alt%3D%22address.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3423021%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20cell%20value%20from%20address%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3423021%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1400148%22%20target%3D%22_blank%22%3E%40Norm_Dotti%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20use%20the%20INDIRECT%20function%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DINDIRECT(ADDRESS(P4%2C13))%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Eor%2C%20since%20column%2013%20is%20M%2C%20use%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DINDEX(M%3AM%2CP4)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3423290%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20cell%20value%20from%20address%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3423290%22%20slang%3D%22en-US%22%3EDuh!%26nbsp%3B%20Yes!%26nbsp%3B%20OF%20COURSE%20the%20INDIRECT%20function!%26nbsp%3B%20It%20IS%20indirect%20addressing%2C%20just%20like%20in%20machine%20language%20programming.%26nbsp%3B%20Anyway%2C%20to%20be%20clear%2C%20it%20works!%26nbsp%3B%20Thank%20you%2C%20both.%20(I'll%20try%20INDEX%2C%20too%2C%20just%20to%20try%20it.)%3C%2FLINGO-BODY%3E
New Contributor

I know I'm doing something dumb. I have a vector of row numbers. I can use them and column numbers in the ADDRESS function to return Excell addresses containing a number I want to get, e.g., ADDRESS(P4,13) returns $M$722.  (P4 is the cell that contains the number 722, in the vector of row numbers.)  What I really want is the number/contents in cell $M$722.  I can figure out how to take the cell address to return the number.  It seems like the $M$722 is acting like it is text.

3 Replies

@Norm_Dotti 

=INDIRECT(ADDRESS(P4,13))

You can try this formula which works in my sheet.

address.JPG

 

@Norm_Dotti 

You can use the INDIRECT function:

 

=INDIRECT(ADDRESS(P4,13))

 

or, since column 13 is M, use

 

=INDEX(M:M,P4)

Duh!  Yes!  OF COURSE the INDIRECT function!  It IS indirect addressing, just like in machine language programming.  Anyway, to be clear, it works!  Thank you, both. (I'll try INDEX, too, just to try it.)