When using the Month Function, by default, it returns one digit day number if it is the month from January to September, while the Text function will return a text string For example, 5/8/11 will return 5 when using the month function, and return to 05 or the month name12)) End Sub Try this Where A1 cell contains month name try this This solution didn't work for me (Excel 10), I had to shorten the month name to 3 characters and add the day number in front of the shortened stringThat way, every time there was a month number, excel will now spit out a month name right next to it Key Takeaways When using VLOOKUP make sure to set the stage first I recommend creating your Lookup Table of reference values in a separate worksheet called "Lookup Values" Also, set it up so the Lookup Value (input value) is 8 Ways To Extract The Month Name From A Date In Excel How To Excel Excel month name from number