girapas
Board Regular
- Joined
- Apr 20, 2004
- Messages
- 150
I've named local holidays of each year as holidaysXX where XX refers to the year (XX=14 for 2014, XX=15 for 2015 etc.).
A user enters a date in A1.
How can enter the MATCH function argument lookup_array, for example MATCH($A1;holidaysXX;0), where XX is the two rightmost digits of the date in A1 year?
Thanks in advance
A user enters a date in A1.
How can enter the MATCH function argument lookup_array, for example MATCH($A1;holidaysXX;0), where XX is the two rightmost digits of the date in A1 year?
Thanks in advance