You are viewing a single comment's thread from:
RE: How to carry out a VLOOKUP within Text in Excel
Excel Learn and Earn Activity 6:
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)