Forum Discussion
Solved
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} ) )
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?
Thanks
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?
Thanks
Wyn 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?- Cell a1 has a whole string of words. table c1:d2 has the words i want to extract. Think of a bank statement that has descriptions of transactions. I have a table of short descriptions I want to use instead of the long descriptions that comes from the bank. Does that help?
