Forum Discussion

Rachel1950's avatar
Rachel1950
Copper Contributor
Nov 19, 2023

Additional criteria added to a formula now it wont work

Good Morning, The following formula worked: =IFERROR(IF(SMALL(IF(($E2:$E13000=E3)*NOT(ISNUMBER(SEARCH("IQVIEW-SC-B-IQ4",$D$2:$D$1300))))*(NOT(ISNUMBER(SEARCH("SENTE-400300212", $D$2:$D$13000))))*(N...

Resources