Anyone know why this statement isnt working, in terms of the wildcard component?
I am trying to be able to use the IF component to search cell E20 with wildcards, but have tried a bunch of combos that dont work - any idea?
=IFERROR(INDEX($C$2:$C$2501, SMALL(IF(" * "&E20&" * "=$B$2:$B$2501, ROW($B$2:$B$2501)-ROW($B$2)+1), ROW(B1))),"")
Aucun commentaire:
Enregistrer un commentaire