Formats Rules Conditional

[Sirfyaad]

I want to match both tables together. I want the 'Formats rules Expression' to work if the 'channel' and 'quantity' columns in the 'scan sheet' match with the 'channel' and 'quantity' columns in the 'photos' table. Otherwise, it shouldn't work. Also, I want to ensure that if the 'channel' is not equal to the 'quantity,' the 'Expression' should not work. 

AND(
IN([CHANNEL], SELECT(photos [CHANNEL], TRUE)),
IN([QUANTITY], SELECT(photos [PAIR QTY], TRUE)),
LOOKUP(
[CHANNEL],
"Photos",
"CHANNEL",
"PAIR QTY"
) = ANY(
SELECT(photos [PAIR QTY], [CHANNEL] = [CHANNEL])
)
)