If you want to avoid the error, you can amend your formula as follows:

=IF (ISNA(Vlookup formula), 0 , Vlookup formula)

This will return a zero instead of #N/A

Pete