The text function that is needed in this case is called MID
The full formula that I used is =VLOOKUP(MID(A2,4,2)+0,$E$1:$F$7,2,FALSE)
- Kenroy Hunter
This comment was made by a guest account using @steempress. Rewards will be sent to the user once they have a Steem account