Forum Discussion
Wildcard in Match
Wyn Hopkinsshould be around and starting his day about now.
My comments would be that I would expect 'Mylist' to refer to a single column of keywords (your INDEX formula has only a row parameter). I would expect the row number to be one of {1;2} so, to start with, you could use this array constant in place of ROW($1:$2) [number larger than the length of your keyword list will give rise to #REF! errors]. The final point is that I expected that it should be the elements of 'Mylist' that you are searching for in the text description. Overall, something like
= INDEX( Mylist, SUMPRODUCT( ISNUMBER( SEARCH(Mylist, Description) ) * {1;2} ) )
PeterBartholomew1 Wyn Hopkins I fixed the #Name problem, Now I get #ref. Please look at https://www.dropbox.com/s/nitvmonpsw57pl7/Screenshot%202019-12-16%2011.07.21.png?dl=0
Wyn Hopkinsshould be around and starting his day about now.
My comments would be that I would expect 'Mylist' to refer to a single column of keywords (your INDEX formula has only a row parameter). I would expect the row number to be one of {1;2} so, to start with, you could use this array constant in place of ROW($1:$2) [number larger than the length of your keyword list will give rise to #REF! errors]. The final point is that I expected that it should be the elements of 'Mylist' that you are searching for in the text description. Overall, something like
= INDEX( Mylist, SUMPRODUCT( ISNUMBER( SEARCH(Mylist, Description) ) * {1;2} ) )
PeterBartholomew1That worked. Thank you!