Checkbox is ticked when 3 cells match.

Graham Rimell

Hi,

I'm looking for a way to make a checkbox ticked when 3 cells all have matching data in.

P/N Actual

P/N OPP LLP list

P/N F12

These should all contain matching part numbers, and if they don't we need it to flag up that they don't.

What's the best way to set up a formula to do this? Been messing around with IF Statements but can't get it working.

Thanks!

Garrett Henke

This formula should work for what you are trying to do.

=IF(AND([Part 2]@row = [Part 1]@row, [Part 3]@row = [Part 1]@row), 1, 0)

Bassam Khalil

Hi @GrahamR

Hope you are fine, Please add a copy of your sheet or a screenshot (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.

Graham Rimell

Essentially this is what I want. 3 Cells with data in, if all 3 cells match then the checkbox at the end of the row is checked. If they don't match then it's not checked.

I can get it to work with 2 cells, just not 3.

Garrett Henke

This formula should work for what you are trying to do.

=IF(AND([Part 2]@row = [Part 1]@row, [Part 3]@row = [Part 1]@row), 1, 0)

Graham Rimell

Thank you! That was the ticket. Nice and simple solution.