Well, your description is "all over the place"!

=MAX(IF($C$2:$C$14613=N$35,IF($A$2:$A$14613=$L37 ,$E$2:$E$14613)))

First, your formula returns a value from column E.

Then you say:

return the value of the cell that is located immediately
to the left of cell that contains the value produced
by the formula above

Ok, so if the formula returns a value from column E then you want this new
formula to return a value from column D.

But then you say:

if the formula returns a value that is found
in cell $C$17, I want to know what value
is in cell $C$16.

Ok, column C is not to the immediate left of column E and C16 is *above* C17
and not to the immediate left!

So, when you figure out what you want I'm sure we can come up a formula to
do it!

--
Biff
Microsoft Excel MVP


"icystorm" wrote in message
...
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