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

Options

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!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!