I know this isn't correct, because I don't understand what you mean by the
lookup of A3, but here's a starter

=INDEX(J1:J1000,MATCH(MAX(IF(J1:J1000<0,(H1:H1000 ))),H1:H1000,0))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Matthew Balch" wrote in message
...
I have:-

=SUMIF('Issue Analysis'!A:A,AND('Titles List'!A3,'Issue
Analysis'!J:J0,MAX('Issue Analysis'!H:H)),'Issue Analysis'!J:J)

Explanation of what Im trying to do:-

I want to return the value in column J that is highest value of column H,
but if the highest value of column H has a respective column J value of 0,
then look at the preceeding MAX in column H, all based upon the lookup of
A3
in the column A.

Hope this makes sense.

Thanks in advance