When you just want to determine if a value exists in a list then I recommend using COUNTIF over VLOOKUP. ... VLOOKUP cannot do this, it only returns the first match. If the value does not exist, COUNTIF will return a zero (0). You do not need to worry about a formula error.

Regards,
Jerry