mercredi 22 novembre 2017

Wildcard Error in Excel Formula

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