mercredi 6 février 2019

how to find a value that's contains from value from other cell

=IFERROR(INDEX($L$1:$L$100000,SMALL(IF(A$1=$H$1:$H$100000,ROW($L$1:$L$100000)- MIN(ROW($L$1:$L$100000))+1,""), ROW()-2)),"")

This is current code that I use now. it compare a1 to h1 to h100000 rows to see if h column has a1 value. If column H has a1 value it will show l column data. However, I want to change code to, if column H contains(like) a1 then return data L data.

So I've tried below code to make that happen, but its not doing anything.

=IFERROR(INDEX($L$1:$L$100000,SMALL(IF("*"&A$1&"*"=$H$1:$H$100000,ROW($L$1:$L$100000)- MIN(ROW($L$1:$L$100000))+1,""), ROW()-2)),"")

How can i make this code to make it work?

Aucun commentaire:

Enregistrer un commentaire