|P.S. To avoid #N/A when a value can't be found, wrap the VLOOKUP in an IF statement:|
This will attempt the VLOOKUP, but if the value isn't in the list, it will return Not Found instead of the error. If the value is found, then it will return whatever it is that VLOOKUP is supposed to return.
Note: I split the formula across 2 lines for ease of viewing. You will have to put it back together for it to work in Excel.