Spreadsheet search

Hello all! I have a customer database which I need a search feature for.
I am not very adapt with Excel and don't know anything more than the basics; I don't want to use Access, nor know about macro either.

Basically, I have all my customers neatly organized by name, phone, address and zip, etc in a single spreadsheet and need an easy way of searching for people with a user-friendly system.

I hope to make it look like this:
public.eternalcode.com/example.png

For convenience I've uploaded the spreadsheet below:
public.eternalcode.com\customerdatabase.xlsx

I would like the search results to be updated as the user (yourself) types in the search text-boxes.

I've researched so hard to achieve this without results. If someone could do this for me I wouldn't be able to thank you enough!
I seriously don't have a clue what I'm doing! and am rather upset because I've needed this for a while now!
I know you guys have great knowledge on this, I only wish I had found you earlier.

Hi James and welcome to the forum,

Pressing Ctrl-F in Excel bring up a Find box that will search the entire spreadsheet for stuff. When it lands on a cell the user and simply type over the value.

Does that do what you want?

Hi James,

A search interface is build into Excel. It is called Forms or Form View. You can add it onto the Quick Access Toolbar (QAT) and it will do what you ask. read http://www.rondebruin.nl/imageqat.htm.

Also open the attached where I have added it to this file. Click on the icon just above the "out" of the words "Page Layout" at the top of the screen.

You will need to click anywhere in your table of data and then on the icon to show the records in form view. Note the button called Criteria to find any record in the database.

Don't build something that is already there.