Intersect???

  • Thread starter Thread starter Guest
  • Start date Start date
G

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to run excel vba code when cell value changes from empty to entered value. 1
Write to intersect of a row and column 7
intersection formula? need help expanding on it 7
Reverse Index and Match Functions 9
unions, intersections or array constants 23
Conditional Formatting 2
Event recognition. 6
"#VALUE!" Cell Value 1

Back
Top