Basic formula help
 

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

Basic formula help
 

VLOOKUP looks in the first (left hand) column of a range and can report from
any column in the range.
You are trying to look in column B and report from column A
You need Match and Index
Match will find the row number for the temp = 78
Index will look up that row in the A column
Want details?
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"pinehead" wrote in
message ...

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

Basic formula help
 

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