If function "logic test" to read the value in a formula.

Mark

A formula will not read the formula from a cell it references, it will read the value.

If you aren't getting the expected result(s) it could be because there's no match.