Re: =vlookup on 2 columns
- From: Dave Peterson <petersod@xxxxxxxxxxxxxxxx>
- Date: Sat, 11 Feb 2006 13:59:00 -0600
Maybe you could just use a formula:
With the temperature in A1 (in degrees F)
and the windspeed in A2 (in MPH)
put this in A3:
= 35.74 + 0.6215*A1 - 35.75*(A2^0.16) + 0.4275*A1 *(A2^0.16)
Taken from:
http://www.nws.noaa.gov/om/windchill/
windchill (F) = 35.74 + 0.6215T - 35.75*(V^0.16) + 0.4275T *(V^0.16)
T = Temp in degrees Fahrenheit
V = Windspeed (MPH)
Mike wrote:
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
--
Dave Peterson
.
- References:
- =vlookup on 2 columns
- From: Mike
- =vlookup on 2 columns
- Prev by Date: Re: NO COLORS IN MY SPREADSHEETS
- Next by Date: Empty cells
- Previous by thread: Re: =vlookup on 2 columns
- Next by thread: Automatic text from 1 cell to several others
- Index(es):
Relevant Pages
|
