Intersect???

[Guest]

Is there a way to get the value of a cell by findingthe intersection of two
other cells?

ex. the intersection of cell a3 and b1 is b3.

 

[RagDyer]

See if this old post helps:

http://tinyurl.com/6s7xr
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Is there a way to get the value of a cell by findingthe intersection of two
other cells?

ex. the intersection of cell a3 and b1 is b3.

 

[JE McGimpsey]

So why isn't the intersection A1?

If the intersection is always the maximum row and maximum column of the
two cells, try:

=OFFSET(A1,MAX(ROW(A3),ROW(B1))-1,MAX(COLUMN(A3),COLUMN(B1))-1)

OTOH, if it's always the Row of the first reference and the column of
the second reference:

=OFFSET(A1,ROW(A3)-1,COLUMN(B1)-1)