How do i use the If function to Lookup in a chart

[kethrydrake]

I am using Excel 2007. My chart looks like this:
A B C 1 2
1 1 .5 ? .5 8 9
1 9 10

I want to use the values in A1 & B1 to generate the appropriate reference in
C1. So if A1=1 and B1=.5, then C1 should equal the value in the appropriate
cell in the second table.

 

[T. Valko]

I'm guessing that you want the value at the intersection of 1 (A1) and 0.5
(B1).

With your table in the range E1:G3...

=VLOOKUP(B1,E1:G3,MATCH(A1,E1:G1,0),0)

Returns 8.