Forum Discussion
AUTO POPULATING CELLS USING A DROP DOWN LIST
On sheet 1, I have a column with all the months of the year. I made a dropdown list of those months. When I select from the drop down list, any month, I want to auto populate the prior 3 months into ...
Joseph_Longoria , pls try these 3 formulas
| =INDEX($A$8:$A$19,IF(MOD(MATCH($K$1,$A$8:$A$19,0)-3,12)=0,12,MOD(MATCH($K$1,$A$8:$A$19,0)-3,12))) |
| =INDEX($A$8:$A$19,IF(MOD(MATCH($K$1,$A$8:$A$19,0)-2,12)=0,12,MOD(MATCH($K$1,$A$8:$A$19,0)-2,12))) |
| =INDEX($A$8:$A$19,IF(MOD(MATCH($K$1,$A$8:$A$19,0)-1,12)=0,12,MOD(MATCH($K$1,$A$8:$A$19,0)-1,12))) |
You're amazing!!! fixed it Thank you so much!