This formula works for what I am trying to do however, when there isn't a match I want to avoid getting the N/A# message.

=VLOOKUP(E13,Sheet1!A:B,2,FALSE)

How can i fix this?

Is it something along the lines of...........................

=IF(IsError(E13,0,(VLOOKUP(E13,Sheet1!A:B,2,FALSE))

Any suggestiosn???