Hello everyone,
This thread is a follow up to another thread where I got several great answers to my issue.
http://www.excelforum.com/excel-gene...functions.html
Some of the solutions offered were:
Array formula
=IFERROR(INDEX($F$4:$F$15,MIN(IF(ISNUMBER(SEARCH($E$4:$E$15,A2)),ROW($E$4:$E$15)-ROW($E$4)+1,99))),".")
Non-array formula
=IFERROR(INDEX($F$4:$F$15,MATCH(TRUE,INDEX((COUNTIF($A2,"*"&$E$4:$E$15&"*")<>0),0),0)),".")
I came up with several additional issues and was wondering if anyone could please help again (e.g., text but no dates).
I have attached the file which shows the current output with one of the solutions suggested earlier. I added the desired outcome.
Thanks again for your invaluable support!
Bookmarks