Array/Table: Looking up values?

[Solomani]

I have a table set up in excel like so;
A B C
1 x1 y1 z1
2 x2 y2 z2
3 x3 y3 z3

I want to be able to enter the y and x co-oridinetes and have excel
return the value. For instance I want to find out the output for the
combination 1A which is x1. I have not been able to figure out a way
to do this, but I am sure it is possible. I have been trying to use
the if and array funciton to no avail.

Any help appreciated. Thanks.

 

[Aladin Akyurek]

=INDEX($B$2:$D$4,MATCH(1,$A$2:$A$4,0),MATCH("A",$B$1:$D$1,0))

The last argument in Match depends on whether A2:A4 and B11 are sorted in
ascending order. If sorted, replace 0 with 1.

 

[Solomani]

Fantastic. INDEX and MATCH worked great. Thanks guys.