I have an Excel 2007 Spreadsheet that has a drop down list with months OCT through Sept. The drop down list is in Cell O7. If OCT through DEC is selected, I want the Year
"2010" to be put in P7 right beside it. If Jan through Sep is selected I want the Year "2011" placed in P7 right beside it. How can this be done in simple coding or with an If Function or some other way. I thought about DLOOKUP but I just can't get it to work. I could List all of the Years in another sheet for Column A and the Month Name in Column B and do this some way. But, I want the most simplest way to do it. If it can be done logically with an IF. I might like this better. I do not know.