When using a vlookup the value you are looking up must be in the first column of the list (see attached). I've created a simple version and then a more complete version for you to look at. The second formula will display "not in list" if the vlookup cannot find an exact match.