The column you are searching in (A) must be sorted in ascending
order. The Vlookup wizard tells you this.
I'm surprised it doesn't settle for the first entry since your Find
text "W30C" preceeds it alpha-wise. Sort the whole table and try
again. If other things preclude sorting, put a copy elsewhere and
sort the copy.