Share |

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.

  1. PrincessWithSkills
    May 15th, 2009 at 02:22 | #1
    Reply | Quote

    I just emailed a friend w/a link to your Highline videos (for 2007) with a WARNING: His videos are addictive.

  2. ExcelIsFun
    May 15th, 2009 at 03:02 | #2
    Reply | Quote

    Dear PrincessWithSkills,

    Thanks! I hope he finds them useful!

    –excelisfun

  3. qunniq
    July 9th, 2009 at 20:27 | #3
    Reply | Quote

    im actually trying to do this excat thing right now but when i do it i get 31109 when i vlookup the date which is 03/03/1985

    heres the code
    =VLOOKUP(‘Federal Contract & Subcontracts’!A23,Sheet1!$A$2:$C$77,2,0)

  4. ExcelIsFun
    July 9th, 2009 at 23:00 | #4
    Reply | Quote

    Dear qunniq ,

    Try formatting the cell with date format.

    –excelisfun

  1. No trackbacks yet.

CommentLuv badge