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