Excel Forum



Excel Magic Trick 318: MID Text (substring) VLOOKUP Trouble


Extract data with MID and use VLOOKUP to retrieve a date. See how to lookup the middle part of a text string and return a value when the substring is a number shown as text. See how to convert numbers as text to numbers inside a formula.





Got a Question? Ask it Here in the Forum.