Glad it worked.
A couple of hints in case you do more Excel work like this:
1. =IF(ISERROR(VLOOKUP(A2,$D$2:$D$12,1,FALSE)),"Not found","Found")
Using this formula assumes that the data being tested is text. The original formula converted the data in column A from a number to text.
This version of the formula that separated out the 'short' number, converts the text to a number.
3. Sometimes comparing text doesn't work because of spaces around the text - which you can't see. So this version =IF(ISERROR(VLOOKUP(TRIM(A2),$D$2:$D$12,1,FALSE)),"Not found","Found") uses the TRIM function to remove any spaces.
4. When comparing or looking up numbers, there may be minor differences between numbers way out in the last few decimal places, (which don't show in the cell), so use the ROUND() function to round both numbers down to fewer decimal places, and the minor differences will disappear.