We have tried several IF(INDEX formulas but keep getting error messages.

efleming

We are referencing the sheet below with the “BARCODE” and “PIP” column and placing a checkmark on a separate collection sheet. We have tried several IF(INDEX formulas but keep getting error messages.

What we would like to do is check a box on a separate sheet if the PIP is “Red” or keep the box unchecked if the cell in the PIP column is “blank”.

Thank you in advance!

Mike TV

@efleming

So if it's Red you want the box checked. If it's blank you want the box unchecked. What do you want to happen if it's Green? You have to define all variables.

Mike TV

@efleming

So if it's Red you want the box checked. If it's blank you want the box unchecked. What do you want to happen if it's Green? You have to define all variables.