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

K

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
formula to make the value in a cell, to a row in a sum function 5
Count column b if column a equal cell value 7
Look up or Match Function? Excuse my ignornace. This could be simple.Variable Upgrades on Furniture 1
adding values if the same - SUMIF in range of cells? 4
if function, how? 4
I need to do a calculation based on the values in two cells 2
use cell text in lookup function 3

Top