Obtain prior month via drop down list of months (text value)

[anderma8]

I have a drop down list of January thru December as a text value. I'm trying to convert that value to an actual month and calculate the prior month so I can ultimately use that in a vlookup. I've tried a number of manipulations but nothing works.... I have too much work done to change the drop down list to a list of dates. Any ideas would be appreciated!!

 

[Weazel]

I'm not sure I'm following what you mean exactly but maybe something like....

=TEXT(EOMONTH(A2&1,-1),"mmmm")

 

[anderma8]

I'm not sure I'm following what you mean exactly but maybe something like....

=TEXT(EOMONTH(A2&1,-1),"mmmm")

This was EXACTLY what I was looking for. I tested and it works PERFECTLY!! Thank you!

 

[Weazel]

you're welcome, glad it worked for you