Cell referencing in a IF(CONTAINS(OR())) statement

Miguel Lopes

Hello everyone ,

I am trying to use the @cell operator in my sheet , but I am cross referencing sheets and getting an invalid operator I am wondering if I am using incorrect syntax within my function , or braking the rules of the language . If someone could help me correct the formula that would be great !

=IF(CONTAINS(OR("QC " = @cell, "Disposition" = @cell, "Delay" = @cell, "Pending" = @cell), INDEX(COLLECT({Status}, {Lot}, [Int Lot]@row), 1)), INDEX(COLLECT({Status}, {Lot}, [Int Lot ]@row), 1), "Not Started")

Paul Newcome

How exactly are you wanting this formula to work?

Miguel Lopes

@Paul Newcome I wanted the formula to search for those specific status key words in another sheet and then if they are true to display that current status on another sheet if those values are not found to display "Not Started".

Thank you !

Paul Newcome

Are you trying to match on something? Are you able to provide some screenshots for reference?