Forum Discussion
Wildcard in Match
Why does a wildcard in the Match function return a n/a? Here is a screenshot showing it.
https://www.dropbox.com/s/bl37mg5hgs4zmaf/Screenshot%202019-12-15%2010.45.47.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} ) )
13 Replies
- Hi
It's not the wildcard part that's the problem, it's the fact you're trying to reference a 2D array with the MATCH.
MATCH only works when referencing a column or row of cells
What is it that you are trying to do?
ThanksWyn HopkinsI'm trying to extract the word ATM in cell a1 from the table C1:D2. How should I do that?
- Sorry, I don't quite understand.
Can you clarify what you mean by extract the word?
