INDEX MATCH to return last matching row value

Pierre Mostert
Pierre Mostert ✭✭✭✭
edited 05/26/20 in Formulas and Functions

Good day,

I would like to return the last matching row using INDEX MATCH for unsorted data.

In the example below, I would like to return the last Date Log - 2020/05/26 for NODE B?

To return the first Date Log, I use the following formula that works:

=INDEX([Date Log]1:[Date Log]6; MATCH([Search value]1; NODE1:NODE6; 0))

Some assistance will be highly appreciated.



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!