When I enter =IF(C2=P3, "match", "no match"), the result is no match even though they both equal 4.
C2 = 4
P3 = 4 – the four is displaying in the cell. It is the result of this formula:
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(INDEX($V2:$AE2,MATCH(C3,$V$1:$AE$1,0)),"#", 0), "DD", "0"), "TTT", "0"
It is saying I can't compare 4 against a function/formula?
Bookmarks