Quote:
Originally Posted by Reyaaz
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.
|
As I said, please post a sample sheet NO PICS !
OTOH your problem seems to be solved somewhere else . Please read
A message to forum cross posters - Excelguru