=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