Formula to check a box based on multiple criteria

Carlee Schiffner

Hello!

I need to check a box on 1 sheet based on 2 criteria from a second sheet, a serial number and a product name. I have tried using IF(AND( formulas as well as INDEX(COLLECT( but am getting an incorrect argument set error.

Here is my latest attempt: =IF(INDEX(COLLECT({TCH MONTHLY TOTALS Range 4 serial #}, {TCH MONTHLY TOTALS Range 4 serial #}, [Quote Serial #]@row, {TCH MONTHLY TOTALS Range 1 product name}, "Operator")), 1)

Thanks in advance!

James Keuning

I don't think you want an IF.

First, a checkbox needs a TRUE/FALSE result. An IF usually provides a value, unless the IF is designed to return "TRUE" or "FALSE" but that approach is usually more complex than just asking the question.

Second, and IF needs an "if true then..." result and an "if false then..." instruction, and yours does not have that.

Can you explain more about what you are trying to test? What question do you want to answer with the TRUE or FALSE?

Carlee Schiffner

I have two sheets, a master sheet and an individuals sheet. I need to check a box on the individuals sheet if there is a matching serial number on both sheets and product name on the master sheet equals "Operator". If both are true, then the box would be checked.