I seem to recall that I can do an INDEX MATCH formula where I need to match 2 criteria.

Basically, I want to return one variable (delay time) based on 2 matches: Date and Flight number. 2 different sheets, same workbook.

I thought it was INDEX (return value, MATCH (look up, look up against, 0), MATCH (look up, look up against, 0)) but I get #REF! error.

What am I doing wrong?