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

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!

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

=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!

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

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" wrote:

=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!

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

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

=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!

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

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

Thx!

"Bob Phillips" wrote:

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

=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!