How do I write a VLOOKUP function that returns 0's, not neg vals?

[dbsavoy]

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!

 

[Bob Phillips]

=MAX(0,vlookup_formula)

--
HTH

Bob Phillips

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

 

[dbsavoy]

Thanks Bob, this seems to work standalone, but I still can't figure out how
to integrate it with the formula I'm using:
=IF(ISNA(VLOOKUP($A10,Pg2!$A$2:$M$453,Y$3,FALSE)),"",VLOOKUP($A10,'NA
Pg2'!$A$2:$M$453,Y$3,FALSE))

I must be a bit slow on the uptake. Where in this formula can I specify
that neg. values should be returned as Zero?

 

[Bob Phillips]

I think this is what you need

=IF(ISNA(VLOOKUP($A10,Pg2!$A$2:$M$453,Y$3,FALSE)),"",
MAX(0,VLOOKUP($A10,'NA Pg2'!$A$2:$M$453,Y$3,FALSE)))


--
HTH

Bob Phillips

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

 

[dbsavoy]

That did it! Bob, you've made my day.

Thx!