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?
Bookmarks