I have an interesting issue with some logs that I port over ot excel workbooks for review.
I am working with Citrix application logs and am trying to search the description fields for several words.
If one of the words is present than put that word in a seperate cell on a different worksheet.
As an example,
You have an exel doc with two workbooks.
place a sencene in workbook 2 in A1. The lazy dog barked.
place a sencene in workbook 2 in A2. The brown dog barked.
in workbook1 in A1 have a formula that searches workbook2!A1:A2 for lazy and brown
in workbook1 A1 returns lazy
in workbook1 A2 returns brown