title: excel aggregate match return multiple values
body: <p>I have been working on an excel project where I have a list of items with a description field that I am searching and on the second sheet a list of words to search for with associated numbers. If I match on one of the words in the description it returns the number from the second list. I actually found the answer on this on another post (<a href="https://stackoverflow.com/questions/33628660/if-string-contains-word-from-list-return-value-adjacent-to-list-value?answertab=active#tab-top">If string contains word from list, return value adjacent to list value</a>) but I am unable to figure out how to handle multiple matches. If possible I want to return all possible matches. I am too new to comment on that question in particular so I couldn't piggyback. any help?</p>