Check box if a cell value matches with a value in 3 different fields in a second sheet

System

This discussion was created from comments split from: Trying to get a box to check.

Paul Newcome

@LMC Right now it looks like you are looking at only two different fields. To look at the third field you would need a third COUNTIFS similar to how you have the first two.

The syntax issue though is simply a misplaced parenthesis. The closing parenthesis after the first zero needs to be moved to after the last zero so that all COUNTIFS are included in the OR function.

LMC

I need a box to be checked if a cell value in one sheet matches with a value in 3 different fields in a second sheet.

This is what I have but I know the syntax is off.

Paul Newcome

@LMC Right now it looks like you are looking at only two different fields. To look at the third field you would need a third COUNTIFS similar to how you have the first two.

The syntax issue though is simply a misplaced parenthesis. The closing parenthesis after the first zero needs to be moved to after the last zero so that all COUNTIFS are included in the OR function.

LMC

@Paul Newcome , thank you so much! That was the fix I needed.

Paul Newcome

Happy to help. 👍️