Search Box that searches and retrieves data from another sheet

Hi guys.

I've got a spreadsheet (sheet1) that has details of vehicles helpline numbers.

I want to create search box on a seperate spreadsheet, where the user enters a reg number, and it is searched for in sheet1. The row containing the result is then shown under the search box. Is there anyway to do this?

Also, I'd like to lock sheet1 so people dont see anything other than their search criteria. (ideally, I'd like sheet1 to be in a totally separate workbook).

Please help!

There are various approaches including the VBA Find method, AutoFilter or AdvancedFilter. Consult the VBA help, or post back with more specific details if you need help.