How do I create a search engine within an excel spreadsheet?

No problem - just a slight change to the formula in column A of the Search sheet, as I had used IFERROR in there. I've made the adjustments and saved it as an XLS file. You will need to copy all your data into the five sheets and copy down the formulae in columns A of those sheets and column B of the search sheet.

Hope this helps.

Pete

Just a quick question: If I didn't have to sift through the worksheets (as in I have one 1 worksheet), how would I go about implementing a search engine. I looked at the formulas you have set up and was wondering exactly how it worked! Thanks!