The thing with a VLOOKUP, it looks up to the right. So in your example the lookup table is E2:F200, If you swap the Columns around it should work. Otherwise use the INDEX & MATCH, to which I prefer.