Unlock Excel Secrets: Magic Search Bar You NEVER Knew About!

#excelformula #exceltips #ExcelSearchBar

Hello Friends,

In this video we have explained, how to create a magic Search Bar in Excel using Excel Shapes, Form Controls and ActiveX Control. We have not used any VBA coding to create it.

Subscribe our new YouTube Channel:

Click below link to download the practice file:

Watch the Step by Step tutorial for Project Plan (Gantt Chart) in Excel

Download our free Excel utility Tool and improve your productivity:

See our Excel Products:

Visit to learn more:

Watch the best info-graphics and dynamic charts from below link:

Learn and free download best excel Dashboard template:

Learn Step by Step VBA:

Website:

Facebook:

Telegram:

Pinterest:

LinkedIn:

Twitter:

Instagram:

Visit our Amazon Store

[tonyross]

Very clever. A lot of relatively simple techniques combined to create a complex solution.

[debashismandal]

You just solve my whole problem. Searched this since 6 months ago. Even chat gpt didn't understand my problem. Thank you sir... ❤❤❤

[finguy]

This is probably the best Excel video I’ve ever seen! I am now looking for any excuse I can come up with to use it!

[osoriomatucurane]

Savvy, outstanding!
Unmatched or unparalled skill.
PK, the Excel Legend

[jackcurl]

Great explanation, clearly demonstrated.

In general, perhaps use IFS or SWITCH(✔) rather than nested IF statements—it's cleaner, easier to debug, easier to read, and certainly easier to program. Both functions became available with Office 2016. If you have FILTER, you have these functions (and a slew of other niftiness).

An example for those who might wondering:
SWITCH($A$1, 1, Search_Left, 2, Search_Right, 3, Search_Anywhere, "No results")

The test/result for the value 3 is included to handle invalid data. It's better to specify than to default. Since A1 is an openly editable cell, any value could appear there. We need to take that into account. Never trust users (even oneself) to always do it right. As the saying goes, An idiot-proof system just hasn't been introduced to the correct idiot yet.

[ioitkee]

Wow! This is an incredible combination of quite simple elements! I applaud standing!
PS
I just don't know where to apply it, but it's a very beautiful and elegant solution

[samprime]

It is very very nice to sit and watch the amazing things we can do with excel. Big Salute.

[nadermounir]

Brilliant PK greatly enjoy the video 📹 👍 keep up the good work. We really thank u for your hard work

[philipjacob]

Thank you PK. Excellent. Keep up the good work.

[mohammedhassan]

Superb idea and technique, Great work without using any coding, excellent

[marcjacquemet--fotalch]

Wow what a great video. I've learned a lot. I already knew individual techniques - but in this video everything was put into a clever context - and a lot was also new to me. Thanks!🤩

[querrythis]

Highly recommend this dynamic search. The best (hands down) I've come across.

[rajsahu]

Doing very well. Wery interesting, useful and beautiful. I have seen several persons videos but no one is so beautyful work representation of figures/Data and chars I have seen from others. Thanks very much to you.

[misdin]

Very nice video, very good, incredible trick. Thank you very much 👍

[irfanchauhan]

Great Sir.... We have improved our knowledge by watching your videos and Practice Thank for you I really appreciate your contribution for us and all @ FREE OF God Bless You Sir 🙏

[lukasolsovsky]

Very well done sir !! I´m used to use it indirect and named_ranges but with FILTER formula it has another level ! Thank you for your video. BR from Czech Rep.

[jaikritbhattacharya]

Brilliant and very catchy... learned something. thanks

[bilalsheikh]

Totally impressive. Stay blessed. Such excellent and elaborated explanation of each step.

[jimmytee]

This is amazing, I have been looking for something like this, we are are creating a mini database for a running club, with this video it going to be a game changer. Thank u ok u so much for that's awesome video

[markus_aurelius_]

Great vid, fantastic that you use formulas instead of programing, it makes life so much easier. 👍