Hi
I have a list of book titles in A1:100.
In cell C1 the user enters a string of one word (and, if possible, two words separated by a space*)
In cells D1 to D5 I need formulas to return the full book titles that contain the word or words the user has entered.
*e.g. if "Journey to the...