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 réponses

via55 Posted messages 14730 Registration date   Status Membre Last intervention   2 755
 
Hello

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

Best regards
Via

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