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)
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)
RE: How to carry out a VLOOKUP within Text in Excel