Sample sheet
Thanks for your response, Pecoflyer.
In the attached example, the user types HR into the search box and a number of rows are pulled up which include HR.
A17 is fine as a search result, as it includes HR as a single word.
C15 and B16 are not, as they only include the word through, and not HR.
The info is gathered from the second sheet.
|