To write the formula combining the two we use the MATCH function to for the row_num argument. We can now rewrite the INDEX formula like this to. INDEX data_array MATCH vlookup_value lookup_column_range 0 MATCH hlookup value lookup_row_range 0.
Without concatenating values in a helper column or in the formula itself theres no way to supply more than one criteria.
MATCH H1A2A130 is the first item solved in this formula. The INDEX MATCH formula is the combination of two functions in Excel. The MATCH function returns a 4 to the row_num argument in INDEX. I found a formula on internet that allows me to check if a date-value in a certain cell falls within the date range of a school holiday.