google-sheets - 谷歌表格试图匹配另一个标签上两列的数据
问题描述
我有一个公式,只要它试图匹配的所有数据都在 A 列中,我就需要它来查看 B 列中的数据,看看它是否匹配。我还有另一个匹配两个不同列的公式,我还需要它在 A 和 B 中查找数据。这两个都用于条件格式。谁能帮我设置这些,以便在 A 列和 B 列的“已接收”选项卡上查看?
当前有效的公式:
=match($C:$C, indirect("Received!A2:A"),0)
=and(match($I:$I, indirect("Received!A2:A"),0), (match($O:$O, indirect("Received!A2:A"),0)))
我正在尝试做但不工作:
=match($C:$C, indirect("Received!A2:B"),0)
=and(match($I:$I, indirect("Received!A2:B"),0), (match($O:$O, indirect("Received!A2:B"),0)))
解决方案
尝试:
=OR(MATCH($C:$C,INDIRECT("Received!A2:A"),0),MATCH($C:$C,INDIRECT("Received!B2:B"),0))
和:
=OR(AND(MATCH($I:$I,INDIRECT("Received!A2:A"),0),(MATCH($O:$O,INDIRECT("Received!A2:A"),0))),
AND(MATCH($I:$I,INDIRECT("Received!B2:B"),0),(MATCH($O:$O,INDIRECT("Received!B2:B"),0))))