Vlookup, Modify Returned Values

[Laustad]

I am using the Vlookup Function to return product quantities for upload to a re-seller site. My problem is that I can not have a negative value in the quantity so I need the Vlookup to return any negative number as a zero.

Here is the code I am currently using to return the values and remove any N/A =IFERROR(VLOOKUP(H2,E:F,2,FALSE),"0")

 

[T. Valko]

I am using the Vlookup Function to return product quantities for upload to a re-seller site. My problem is that I can not have a negative value in the quantity so I need the Vlookup to return any negative number as a zero.

Here is the code I am currently using to return the values and remove any N/A =IFERROR(VLOOKUP(H2,E:F,2,FALSE),"0")

Try this...

=MAX(0,IFERROR(VLOOKUP(H2,E:F,2,0),0))

 

[Laustad]

Try this...

=MAX(0,IFERROR(VLOOKUP(H2,E:F,2,0),0))

Perfect! Thank you T. Valko, worked like a charm.

 

[T. Valko]

Perfect! Thank you T. Valko, worked like a charm.

You're welcome. Thanks for the feedback!