In the attachment I need a function to reside in cells C1:C9, that looks at long text string in adjacent col D for words/numbers that match any in list of text/numbers within col A. If TRUE return the adjacent value in col B.
Example: Formula in cell C2 looks at text string in D2 for a match from Col A:A. It finds a match with 'MDN' and 'Maiden' and returns value '20'
Thanks