software

Where to start... I'll give you a gernal overview of my sheet.
A B C D
DAYTEMPRATUREWEATHER
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 quot;max, min, count, countif, sum sumif, if average,
vlookup.

Thank you for any help you can provide.--
pinehead
------------------------------------------------------------------------
pinehead's Profile: www.excelforum.com/member.php...oamp;userid=31721
View this thread: www.excelforum.com/showthread...hreadid=514393VLOOKUP 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

quot;pineheadquot; gt; wrote in
message news
gt;
gt; Where to start... I'll give you a gernal overview of my sheet.
gt; A B C D
gt; DAY TEMPRATURE WEATHER
gt; 1 5 SUNNY
gt; 2 30 CLOUDY
gt; 3 15 SUNNY
gt; 4 57 SNOW
gt; 5 78 RAIN
gt; 6 98 CLOUDY
gt; A,B,C,D BEING THE COLUMS.
gt;
gt; I'm trying to right a formula that looks in column c for the temp 78.
gt; Ass soon as it finds the row with temp of 78 i want it to give to
gt; display in a cell the day on which the temp was 78. So some number
gt; from cell a.
gt;
gt; I was attempting to use vlookup
gt; vlookup(78,c1:c6,2,false) however it has not worked for me.
gt; I'm attempting to stay within the use of these following functions to
gt; write my formula quot;max, min, count, countif, sum sumif, if average,
gt; vlookup.
gt;
gt; Thank you for any help you can provide.
gt;
gt;
gt; --
gt; pinehead
gt; ------------------------------------------------------------------------
gt; pinehead's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31721
gt; View this thread: www.excelforum.com/showthread...hreadid=514393
gt;
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))

quot;pineheadquot; wrote:

gt;
gt; Where to start... I'll give you a gernal overview of my sheet.
gt; A B C D
gt; DAYTEMPRATUREWEATHER
gt; 1 5 SUNNY
gt; 2 30 CLOUDY
gt; 3 15 SUNNY
gt; 4 57 SNOW
gt; 5 78 RAIN
gt; 6 98 CLOUDY
gt; A,B,C,D BEING THE COLUMS.
gt;
gt; I'm trying to right a formula that looks in column c for the temp 78.
gt; Ass soon as it finds the row with temp of 78 i want it to give to
gt; display in a cell the day on which the temp was 78. So some number
gt; from cell a.
gt;
gt; I was attempting to use vlookup
gt; vlookup(78,c1:c6,2,false) however it has not worked for me.
gt; I'm attempting to stay within the use of these following functions to
gt; write my formula quot;max, min, count, countif, sum sumif, if average,
gt; vlookup.
gt;
gt; Thank you for any help you can provide.
gt;
gt;
gt; --
gt; pinehead
gt; ------------------------------------------------------------------------
gt; pinehead's Profile: www.excelforum.com/member.php...oamp;userid=31721
gt; View this thread: www.excelforum.com/showthread...hreadid=514393
gt;
gt;