Sorry - the original posting was just using examples. I should've said that some of the choices are multiple words.
So instead of "January" in the first drop down, lets say the choice is "January One"
I'd probably have to use a SUBSTITUTE in there, right? I tried doing that and I couldn't get it to work either.
Also, I have a separate list in the workbook titled "Contacts" - Will that affect this formula?
Thanks again!
Bookmarks