Normally an INDEX MATCH formula is configured with MATCH set to look through a one-column range and provide a match based on given criteria. INDEX and MATCH are Excel lookup functions. Lets say we use a normal INDEX MATCH formula to look up Davids salary.
Here is one example to IF INDEX and MATCH combination in Excel.
To perform advanced lookups youll need INDEX and MATCH. Because the date is returned as a number we use the TEXT function to format it as a date. INDEX and MATCH are Excel lookup functions. Separating the MATCH when the search is required once and the corresponding values are picked up for multiple items but those cases are more nuanced.