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

[qunniq]

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)

[ExcelIsFun]

Dear qunniq ,

Try formatting the cell with date format.

--excelisfun

[PrincessWithSkills]

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

[ExcelIsFun]

Dear PrincessWithSkills,

Thanks! I hope he finds them useful!

--excelisfun