I want to use "exact" insted of "search" in column G because of cell b4.
exact and search retun true but when i put into isnumber i dont get the result i am expecting see I2
does not work {
=IF(OR(D3=0,D3=""),"",SUMPRODUCT(--ISNUMBER(EXACT("Yes",Con)),--ISNUMBER(EXACT(D3,List))))
/} (Ctrl+Shift+Enter)
Bookmarks