I am using the following formula to Find Text within a String using a Named List.
=ISNUMBER(MATCH(TRUE,ISNUMBER(SEARCH(Names,E2)),0))
Unfortunately the Formula only returns a value of True or False.
How can I modify the Formula to return the Text in the Named List.
Thank you.
Bookmarks