We have tried several IF(INDEX formulas but keep getting error messages.
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!
Help Article Resources
Check out the Formula Handbook template!