Need help adding a search field in my spreadsheet

[greenbirdredbeak2015]

Hi,
I have a spreadsheet, with column names (first name, last name, phone number, etc.) and I need to add in a search field, so if I type "Michelle" in the search field, it searches the sheet and lists (filters) for cells that contain "Michelle".

I KNOW there already are filters in tables and ctrl +F to find, but my boss requested a search field specifically.

Can someone help me?

No VBA please.

 

[JackDanIce]

Based on the description you've given, a VBA based solution is the only way to achieve what you need.

Failing that, ask your boss if he has an example of a search field feature that does not use VBA for you to base your solution on.

Generally you should try to keep it as simple as possible - using a filter is ideal.