Is it possible to search an excel file and place the results found on the first sheet, so that i can then protect the rest of teh document and hide it?

I need the search to be carried out by typing the info into a cell, but sometimes it will have more than one entry, so i will then need a way to select the appropriate one.

Thanks for reading

You'll need to explain in more detail what you're trying to do, especially the bit at the end about selecting the appropriate one.

If you want to search by typing something into one cell and have matches show in some other cells - where the data you are searching through is held on another sheet - then it can be done.

I'd suggest starting with the VLOOKUP / HLOOKUP functions. You refer to data on another sheet with sheet name!cell reference, example 'Sheet2!C10'. Can't suggest more without knowing the layout of the sheet you want to search through.