Real-Time Multi-Column Data Search Box in Excel with FILTER function [Part 2]

Dynamic Multi-Column Data Search Box in Excel with FILTER function [Part 2]

In this tutorial you will learn how to implement multi-column search for a dynamic data search box in Excel.
Based on the implementations of Part 1 (using the FILTER function), this part covers
- how to dynamically select the search column via a dropdown list
- how to search in multiple search columns via checkboxes (with one single search box)
- how to search in multiple search columns with multiple search boxes (one per search column)

00:00 Introduction
01:13 Recap part 1
03:32 Dropdown selection for search column
10:04 Multi-column search with checkbox selection
18:32 Multi-column search with multiple search boxes
22:56 Search mode dropdown selection for all implementations

This tutorial requires the latest Excel version (Excel in Microsoft 365).

🔎 EXCEL FUNCTIONS COVERED IN THIS TUTORIAL

- FILTER Function
- ISNUMBER Function
- SEARCH Function
- LEFT Function
- INDIRECT Function
- IFS Function

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

You want to show your support and help me grow?
Here is what you can do.

☕ WANT TO MAKE MY DAY?

🔥 MORE AWESOME EXCEL AND POWERPOINT CONTENT

Note: Some of the links in this description are affiliate links, meaning, at no additional cost to you, we will earn a commission if you click through and make a purchase. This supports the channel and allows us to continue to produce videos like this. Thank you for your support!

#excel #searchbox #filter

[michaeljameshaywood]

You are the real MVP. Your tutorial helped me eliminate a ton of duplicated work by collecting the research data of an entire team into one database and using your search formula to prevent duplicated searches. You are a hero in my books, whoever you are.

[Ismail-Yahya]

This channel is seriously awesome! Thanks for the upload

[edobeirne]

Yeah! Thanks man. I used your lesson to create a tool for medical coders to look up which procedures to code or not to code for a hospital admission. I only needed the multi-column general search (no checkboxes) but I appreciate your methodical building block approach to teaching this. I am an educator myself and so I notice these things. Great job!

[lmajiedmary]

Wow!!! You are a genius!! Excellent job!! Perfect explanation!! I subscribed in Part 1 already!! Can't wait to look at some more of your tutorials!! Thank you so much!!

[kimams]

Amazing tutorial video. This is exactly what I need for a project I am doing now. Thanks a million. Subscribed!!!

[patrickschardt]

Well explained and easy to follow. Great stuff.

Instead of INDIRECT with a hardcoded table name, I would have used INDEX MATCH (or XMATCH). I would compare the table headers to the selected search columns. Finally I would use FILTER to return the results in those columns and then use FILTER again to return the results of the search box

[tonih.]

Excellent tutorial, thank you so much!!

[littleemoonster]

You are a life savior sir, thank you sooo much!!! Subscribing, no doubt 'bout that

[bindureddy]

Great Tutorial, this helped us a lot. Thank you!

[danicyc]

thank you so much!!!! this was very helpful!!!

[douglasnakano]

Just amazing! Thanks a lot for the great tutorial!

[UpExcel]

Really clever stuff in here and I love the fact you've managed it without any VBA or having to save the file as macro enabled despite using some ActiveX controls 👍

[mario-t]

amazing !!!! you're the best. tx much

[hyweltthomas]

Fantastic, it works brilliantly. Any idea of how to restrict the columns showing in the filter list?

[evabardun]

Super helpful! I actually have a good test to do alongside the video, however, my data is showing up the "Partial Match" box before I enter anything in the search box. How do I keep it empty until I enter something?

[senhorrichardootimo]

Awsome tutorial. I tried this and it works great. But is it possible to create this in a way that one can edit and update the original tabel in the search results?

[rickyboisseau]

Once I have this setup. If I wanted to use the data found in the search field to delete from the source table, would I be able to do that?

[gavincato]

Great video, thanks for taking the time to make it. I have followed your tutorial with great success. Question: Once you have the results you want, how to you edit a record?

[randomite]

Great tutorial! Is there a way to make it scalable so we can search thru a bunch of columns say that we provide in another table? (instead of adding each line for each column)

[FrozenPeaches]

Is there a way to add an additional date filter if the each entry has a date variable?