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} ) )
Wyn HopkinsI'm trying to extract the word ATM in cell a1 from the table C1:D2. How should I do that?
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?
That's a tricky one
There's a good article on it here
https://www.myonlinetraininghub.com/excel-search-string-for-a-list-of-words
Wyn HopkinsNow I get a #Name error. Here is the screenshot https://www.dropbox.com/s/azv3nzpo8poa7s5/Screenshot%202019-12-16%2008.22.33.png?dl=0