I
icystorm
I have a formula that returns a result...
=MAX(IF($C$2:$C$14613>=N$35,IF($A$2:$A$14613=$L37,$E$2:$E$14613)))
How do I return the value of the cell that is located immediately to
the left of cell that contains the value produced by the formula
above?
In other words, if the formula returns a value that is found in cell $C
$17, I want to know what value is in cell $C$16.
I thought the solution may involve offset(), but I cannot seem to make
it return the correct result so I think that is the wrong approach.
Any ideas?
Thanks!
Joseph
=MAX(IF($C$2:$C$14613>=N$35,IF($A$2:$A$14613=$L37,$E$2:$E$14613)))
How do I return the value of the cell that is located immediately to
the left of cell that contains the value produced by the formula
above?
In other words, if the formula returns a value that is found in cell $C
$17, I want to know what value is in cell $C$16.
I thought the solution may involve offset(), but I cannot seem to make
it return the correct result so I think that is the wrong approach.
Any ideas?
Thanks!
Joseph