vlookup will only work if the data on which you're keying (temperature) is
left of the data you're trying to find (day), which is not the case here.
The alternative is to use MATCH to find where in column C the desired
temperature is found, and INDEX pull the corresponding entry in column B:
=index(b:b,match(78,c:c,false))

"pinehead" wrote:


Where to start... I'll give you a gernal overview of my sheet.
A B C D
DAY TEMPRATURE WEATHER
1 5 SUNNY
2 30 CLOUDY
3 15 SUNNY
4 57 SNOW
5 78 RAIN
6 98 CLOUDY
A,B,C,D BEING THE COLUMS.

I'm trying to right a formula that looks in column c for the temp 78.
Ass soon as it finds the row with temp of 78 i want it to give to
display in a cell the day on which the temp was 78. So some number
from cell a.

I was attempting to use vlookup
vlookup(78,c1:c6,2,false) however it has not worked for me.
I'm attempting to stay within the use of these following functions to
write my formula "max, min, count, countif, sum sumif, if average,
vlookup.

Thank you for any help you can provide.


--
pinehead
------------------------------------------------------------------------
pinehead's Profile: http://www.excelforum.com/member.php...o&userid=31721
View this thread: http://www.excelforum.com/showthread...hreadid=514393