Excel – INDEX / MATCH with different tables and multiple criterias


Older versions of Excel need this entered with ctrl+shift+enter.

This searches your data for the row where the ID meets the criteria (in this example I used G22 for the ID to match). Aggregate checks for a non-empty cell in that range and returns the value in the header. EOMONTH then returns the last day of that month. If there’s no values or matching ID’s it returns as blank.

enter image description here

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top