Return Value in Cell Diagonally opposite

  • Thread starter Thread starter Pete
  • Start date Start date
P

Pete

Can anyone give me a formula that will return the value in a cell that
is diagonally opposite. If the value I search for is found in say B2 I
want to return the Value in C3.

Thanks

Peter
 
See if this does what you want...

...........A..........B
1.......10...........
2......................
3........5............
4.......10.........X
5.......15.........Y
6....................Z

A1 = lookup value

=INDEX(B4:B6,MATCH(A1,A3:A5,0))

Result = Y
 
Back
Top