I have the following VLOOKUP formula copied down through an inventory spreadsheet: =VLOOKUP(Sheet1!B2,Sheet2!$A$2:$B$600,2,FALSE)

The issue is that sheet two, column A is a subset of sheet 1, column B that varies day to day. The #NA result if there is not a current match is causing problems for the end user.

How do I modify this so that it returns the current values if a match exists, but returns a blank cell or a zero if there in no match?

Thanks.