HELP I need find to get an exact match. When it searches for "1" it counts 11, 21, 1 etc
here is my formula
=IF(ISERROR(INDEX(APPROVED!$A$3:$A$1002,SMALL(IF(ISNUMBER((FIND(G$4,APPROVED!$D$3:$Q$1002))*(FIND($H$1,APPROVED!$C$3:$C$1002))),ROW($C$3:$C$1002)-MIN(ROW($C$3:$C$1002))+1,""),ROW(G1)))),"",INDEX(APPROVED!$A$3:$A$1002,SMALL(IF(ISNUMBER((FIND(G$4,APPROVED!$D$3:$Q$1002))*(FIND($H$1,APPROVED!$C$3:$C$1002))),ROW($C$3:$C$1002)-MIN(ROW($C$3:$C$1002))+1,""),ROW(G1))))
Bookmarks