Thank you Paula for this excellent tutorial. I use Vlookup very often and also tried to use LEFT, RIGHT, MID to extract certain characters using using it in Vlookup. But I wasn't successful. Now that I learnt that the information extracted is in text format, I can try out a lot of things at work.
Below are the answers for the exercise:
What text function is needed in this case?: MID
What is the full formula that you used?: VLOOKUP(MID(A2,4,2)+0,E:F,2,0)