Queries

Hey Guys,
My boss needs me to make a search engine tool within excel. We normally have a ton of records within one file and he wants to search "keywords" and based on the keywords in that file, he wants to output some key data.

This is for one of our clients that aren't very familiar with excel, so it's for them and the ease of having something like this available to them (they won't be able to do pivot tables, filters on their own, etc).

Any help would be greatly appreciated!

Thanks,
Andrea

Can you provide a small public sample of the file to be searched, the file containing the keywords and an example of the output you want to see??