If statement return value

**devilchild99** · 10-18-2013, 02:43 PM

Hi there,

What I am trying to do is return a value for a field that is the highest.
I think what I am looking for is an IF statement but I am open to other suggestions.

I am not the best at describing so I included a sample.
If_sample.xls

Cell C14 grabs the max number of the numbers above ranging A2:E10, now I need it to grab the time to the left in which case would be 0700-0800 and than in cell B13 grab the persons name in which case would be TIM.

Thanks for your time and help.

**popipipo** · 10-18-2013, 02:58 PM

=INDIRECT(ADDRESS(1;SMALL(IF(A2:E10=C14;COLUMN(A:E)-1;"");1)))
Try this array formula (<CTRL><SHFT><ENTER>)
It goes wrong with duplicate values eg 25)

**devilchild99** · 10-18-2013, 03:12 PM

Hmm, I took the formula and pasted (with Ctrl, Shift, Enter) but I can get errorr that says The formula you typed contains an error.

**popipipo** · 10-18-2013, 03:30 PM

Change semicolon in colon
In the Netherlands we use the ; to separate the parameters

**devilchild99** · 10-18-2013, 03:38 PM

ahh yes, thanks that worked perfectly, how would I make it show the time in field below?...i am trying to understand the code but I dont fully... so in that case 0700-0800 should be shown...how what do I change in the code to make it show that?