View original (French)

Retrieve a result based on today's date.

Solved
l1607 -  
 l1607 -
Hello,

I would like to retrieve a result based on today's date. Let me explain (A1:L2)
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
| 1% | 2% | 3% | 4% | 5% | 6% | 7% | 8% | 9% | 10% | 11% | 12%

I would like, for example, if we are on 26/08, it displays in another cell (e.g., Z1) the result for the month of August (here 8%), and when we are on 01/09, the result should display that for the month of September (here 9%)

Thank you in advance for your attention to this matter.

Best regards,

Configuration: Windows / Edge 18.17763

3 answers

  1.
    via55 Posted messages 14393 Registration date   Status Member Last intervention   2 759
     
    Hello

    Simply:
    =INDEX(A2:L2;;MONTH(TODAY()))

    Best regards
    Via

    --
    "Imagination is more important than knowledge." A. Einstein
    11