INDEX MATCH with MAX

Hi

Scenario: Reviews are required for people across the firm and some may have more than one review in the year. I need to pull through the date of the last review. My current formula is:

=IFERROR(INDEX({01. File Review Range 2}, MATCH(EEID@row, {01. File Review Range 5}, 0)), "")

This index's the last review date and matches the Employee ID in one sheet, to the Employee ID in my File Review sheet.

Issue: When people have more than one review in the year, the latest date is not shown - only the first

Question: Can I add MAX into the nested index match formula to identify the latest date for that person or, do I need a helper column. If I need a helper column what formula would I use to get to my end goal?

TIA

Cheryl

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!