Combine a VLOOKUP and an IF statement?

Let's say for instance I have a vlookup that displays a the quantity of available items in stock pulled from a column in another workbook. Occasionally these numbers are negatives as they are backordered I would like to display these values as zero. Hope this makes sense.

Thanks in advance.