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.