How to reference a cell in a named array?

  • Thread starter Thread starter Excel Novice
  • Start date Start date
E

Excel Novice

I have a range of cells (say A7 thru z43) which I have
named "ARRAY". I want to say something like =ARRAY(5;12)
to refer to cell L11 (I think I counted that right). Even
more I want to be able to do things like =ARRAY(ROW;COL)
where ROW and COL may be variables or functions ....

How do I do this please?

Novice ...
 
=INDEX(ARRAY,5,12)

=INDEX(ARRAY,B1,C1)

where you put the coordinates in cells where B1 in this case holds 5 and C1
12

You can also lookup horizontal and vertical values using 2 MATCH function
and thus get the
contents if, you lookup a value in column A and one in row 7
 
Excel Novice said:
I have a range of cells (say A7 thru z43) which I have
named "ARRAY". I want to say something like =ARRAY(5;12)
to refer to cell L11 (I think I counted that right). Even
more I want to be able to do things like =ARRAY(ROW;COL)
where ROW and COL may be variables or functions ....

How do I do this please?
Click to expand...

=OFFSET(ARRAY,row,column,1,1)
 
-----Original Message-----
=INDEX(ARRAY,5,12)

=INDEX(ARRAY,B1,C1)

where you put the coordinates in cells where B1 in this case holds 5 and C1
12

You can also lookup horizontal and vertical values using 2 MATCH function
and thus get the
contents if, you lookup a value in column A and one in row 7
--

Regards,

Peo Sjoblom





.
Click to expand...
 
Back
Top