Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Lv 59,712 points

SSG Redding

Favorite Answers78%
Answers843

US Army, Active Duty, Enlisted Recruiting NCO

...More

  • MS Excel - fill three cells automatically dependent on value of another cell.?

    I have a drop down menu in a cell in which the user selects the month.

    I have three other cells which indicate the three months prior to the selected month.

    Is it possible to get those cells to automatically populate their given month?

    For instance; I select January in the cell with the dop down menu.

    I want cell X to show Oct, cell Y to show Nov, and cell Z to show Dec.

    I already have the lists configured on a separate spreadsheet within the same workbook, I just can't figure out how to connect the dots.

    How can this be accomplished?

    2 AnswersSoftware7 years ago