What text function is needed in this case? MID
What is the full formula that you used? =VLOOKUP(MID(A2,4,2)+0,$E$1:$F$7,2,FALSE)
That was fun. The really cool part...I've used Text Functions for years and never knew that I could turn the result into a number by adding 0. I absolutely love learning new things!