Use MATCH to find the last position of a matching value.


In the period column I have a MATCH formula to get the position of the matching value in Current Month.

=IFERROR(MATCH([Current Month]@row, June@row:May@row, 0), "")

In this case the value returned is 5.

How would I get the position of the last matching value, which would return 8?

Thank you!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!