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...