Excel Forum
Similar Content
Partial Match Lookup with Numbers in Excel
Tutorial: Perform lookups on numbers with partial matches. For instance, find the first number that...
Excel Function to Remove All Text OR All Numbers from a Cell
Tutorial: How to create and use a function that removes all text or all numbers from a cell, whichev...
Vlookup to Return All Matching Results
Tutorial: Here is an Excel formula that will act like a Vlookup that returns every matching result ...

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.