Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and the Yahoo Answers website is now 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.
Trending News
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 Answers
- KookiemonLv 67 years ago
If [A1:A12] is your list of months and [C2] is your drop-down, then
= INDIRECT( ADDRESS( IF( MATCH($C$2, $A$1:$A$12, 0) - 3 < 1, MATCH( $C$2, $A$1:$A$12, 0)+12 - 3, MATCH( $C$2, $A$1:$A$12, 0)-3), 1))
= INDIRECT( ADDRESS( IF( MATCH($C$2, $A$1:$A$12, 0) - 2 < 1, MATCH( $C$2, $A$1:$A$12, 0)+12 - 2, MATCH( $C$2, $A$1:$A$12, 0)-2), 1))
= INDIRECT( ADDRESS( IF( MATCH($C$2, $A$1:$A$12, 0) - 1 < 1, MATCH( $C$2, $A$1:$A$12, 0)+12 - 1, MATCH( $C$2, $A$1:$A$12, 0)-1), 1))
