Vlookup with part of cell text
Use =VLOOKUP(MID(A2,4,2), ... ) if the required substring is always 4th and
5th characters of cell text!
Regards,
Stefi
€˛Madiya€¯ ezt Ć*rta:
I need to use vlookup but the problem is that my cell contains a
bigger text string.
For e.g. cell text is CL BW 205
I want to use vlookup with BW which will return corresponding value
from the same row, 3rd col.
Is there any way to do this with a formula.
Regards,
Madiya
|