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

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.

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

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.

--
Biff
Microsoft Excel MVP


"kethrydrake" wrote in message
...
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.