Hello All,
Using Excel XP.

I have two columns of data, for example, say temps in column A and wind
speeds in column B.
I want a vlookup formula that would give me a windchill in column C based on
a match in column A & B.

A B C
------------------------------
1 47 6 45
2 47 7 45
3 47 8 44
4 47 9 44
5 47 10 43
6 47 11 43
7 47 12 42
8 47 13 42
9 47 14 41

I checked the old messages in the newsgroup and found this response from Peo
Sjoblom.
I tried applying the formula in the above example by changing the Ranges to
the cells of A to C
and 1 to 9. I'm not sure what goes where the 1 is after MATCH(1,......I
tried putting down the 47 from colunm and leaving it as the 1, but get an
#N/A.
Would appreciate if anyone could help me out on this one,

Thanks,
Mike

=INDEX(Range3,MATCH(1,(Range1="team")*(Range2="jobtitle"),0))

entered with ctrl + shift & enter

where Range3 is the range where you want the result returned from
Regards,

Peo Sjoblom