Return Value in Cell Diagonally opposite

[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

 

[T. Valko]

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