Excel Dynamic Search Box Tutorial | Find Anything | Multi-Column Search

If your data is large and unmanageable, a search box may be just the thing you need to make your spreadsheet more user-friendly! I call these kinds of fun and useful upgrades, “Power Ups”! In this video, I’ll show you step-by-step how to create a magic search box in Excel using the FILTER, ISNUMBER, and SEARCH functions. You’ll also learn about a few key tweaks that can take this feature to the next level.

00:00 Introduction
00:54 Design Search Box
03:46 Insert ActiveX Text Box
06:00 Create Search Results View
06:50 The Formula
09:19 Power Up 1: Gridlines
10:46 Power Up 2: Multi-Column Search
12:01 Note: Partial Matches
12:26 Power Up 3: Exclude Some Columns

[shoasKp]

you know it well and explain simply ;that's what smart teachers do.

[SirThomas-pq]

best video I've seen on this subject! And it worked out -of-the-box. No struggle trying to discover why it wasn't working.

[WavzonRox]

Beautifully presented - precise, clear, concise! Very much appreciate your direct and fast implementation - so much easier than dozens of other videos! And a very useful, simplified method. Will definitely be looking forward to all your posts! Thank You!

[cruzianfibergeek]

I have seen quite a few of these videos on adding search boxes this is the first one that i was able to follow without tuning out. You covered exactly what I need done which is to search a table but return only some of the columns.

[mukhtarsheriff]

Thank you. We need more of your educative tutorials

[mardjes]

Hello, I'm from Brazil. This video helped me to study English and Excel. Thanks.

[wizitchizit]

Definitely gonna play around with this! There are certain functions at work that could be drastically improved with this!

[sealhouselimited]

I literally have spent 3 hours looking other search box tutorials and each failed and took forever, I came upon yours and in 14 minutes it was done and dusted perfectly. thank you for that, you are absolutely awesome.

[ziggle]

Lots of goodies in this presentation: (1) ActiveX gave you dynamic abilities, (2) Good use of "New Rule" in conditional formatting, (3) filtering using multiple criteria, (4) Nice use of paste while keeping column widths. Thanks. You got a new subscriber. 😁

[realmanta]

I have watched several videos on this topic and all presented error in implementation, until this one. Great job! Thank you for sharing.

[AsfM-oq]

Very useful and advanced, yet simply explained. Well done. Thank you

[M.Asif]

You made SEARCH filtering with selective columns so easy, thanks for transferring knowledge.

[wichstad]

Adding a lineshift in the formula was helpful, a new trick i didn't know about. Thanks for a great tutorial

[MSAgha]

Birlliant and very simple, its very helpful and I solve this search with the help of your video. Thank you so much

[deliasantos]

Rebekah Oster- you are an amazing teacher .. you made this so easy to understand. I just did this for a spreadsheet at work and it came out great.. Thank you, looking forward to your other teachings

[kevinbryden]

This was so helpful. I have been trying to catalog our flower beds by location and this helped us find a specific plats location. Now if I can figure out how to display the photo of the plant it would be perfect.

[ExcelTL]

Nice. Hadn't thought of implementing instant search this way. You earned a sub!

[rldb]

Very simple and straight forward video. Liked and subscribed. Thank you.

[RichardJones]

Nice clear tutorial. I done a similar search like this (but not with a fancy searchbox) and used the column headers in the search page to tell the choosecols function what to use, using Match function to get the column number.

[sizable]

Really clear and will definitely use this