Using MATCH() to identify row # on checkbox column

Michelle St George

I have a checkbox column I'm using to identify a specific row in a sheet based on criteria. I'm trying to use the Match() formula in the sheet summary to identify the row number in the checkbox column is checked but its coming back #NO MATCH. Feels like this formula should be easy but I can't seem to get it…

My formula:

=Match(1,[Checkbox Column]:[Checkbox Column])

Paul Newcome

What about with the zero and true instead of 1?

Michelle St George

@Paul Newcome = Winner, Winner, Chicken Dinner! TYSVM!!!! That's exactly what it needed. You've just saved me so much time trying to create the workaround I had in my head.

Final (Working) Formula:

=Match(True,[Checkbox Column]:[Checkbox Column],0)

Paul Newcome

Try using a zero in the third portion of the MATCH function to indicate an exact match.

Michelle St George

Thank you for the suggestion @Paul Newcome - I should have mentioned that I did try that

Paul Newcome

What about with the zero and true instead of 1?

Michelle St George

@Paul Newcome = Winner, Winner, Chicken Dinner! TYSVM!!!! That's exactly what it needed. You've just saved me so much time trying to create the workaround I had in my head.

Final (Working) Formula:

=Match(True,[Checkbox Column]:[Checkbox Column],0)

Paul Newcome

Happy to help. 👍️