You are viewing a single comment's thread from:
RE: How to carry out a VLOOKUP within Text in Excel
@theexcelclub that was an excellent post and tutorial. I 100% enjoyed carrying out the learning activity. Here are my answers
What text function is needed in this case?
I would use the MID function
What is the full formula that you used?
=vlookup(mid((a2,4,2)+0,E1:F7,2,false)
Nice work @dernan, you are correct. thank you for taking part in our learn and earn activity