=MAX(0,vlookup_formula)

--
HTH

Bob Phillips

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

"dbsavoy" wrote in message
...
I need to write a VLOOKUP function that will return a value of "0" if it
finds the number for which it had searched is negative. My thought is to
use
an IF logic function together with the VLOOKUP, but I just can't seem to
successfully weave the two together.

Any help would be much appreciated. Thanks!