Nested If function across several worksheets

[Xandler]

Hello all,

I've ran into a problem trying to use a nested if function (something I'm not very familiar with) to produce a specific number (I basically want to look at all the high temperatures in 3 worksheets of the workbook and return that city's name within the cell), I have it mainly working except that it returns the same city result no matter what. Wondering if there was any insight or tips that would help me figure out the problem I am having (If I'm just using the wrong if function, have it structured wrong, etc). The current formula I have is

Please Login or Register  to view this content.

Like I said it just returns OKC no matter what and I want it to return the others if that high temperature matches.

Thank you

[guru008]

Hi,

Try this , I assumed your data as below

E F
Temp City
16 25 A
17 26 B
18 27 C
19 45 D
20 29 E
21 28 F

INDEX(F16:F21,MATCH(MAX(E16:E21),E16:E21,0))

[Xandler]

Thank you for the reply
That is similar to how I have the data, I just have a date before the high and low temps along with 3 cities with up to a month of temperature data and a summary sheet (Where I'm having the issue) I want to put the name of the high temperature city next to the date in which the data occurred IE 7/1 has high temps of 76 96 78, I want it to pull the 96 from the 2nd sheet and insert that city's name in the cell, I see you used an index and match function for the sample data, will that in effect work for what I require it to do or do I need a different kind of if function?

[Xandler]

I believe I need to format the index and match function with if statements as I've been browsing around looking for examples, I'm just unsure on how to do this unfortunately, like I said it needs to read the input in let's just say it's in Cell F10 for example sake (which has the high temp from all 3 cities in a 3-d sum function) and output the city name in the Cell next to it, which would be G10)

[Xandler]

Figured it out, I was over complicating matters with the nested if function, but I figured it out through trial and error for the most part.