Google Sheets - Create a Dynamic Search Bar with Query and Filter

This is how to create a dynamic search bar using a couple different methods in Google Sheets.

I'll show you ✌️two ways to make a dynamic search bar in a Google Sheet to display data based on what you type.

🤔And I'll explain why one is better than the other.

🔥Let's go!+

We receive commission on purchases made through some links on this page
_______________________________________________

🎓Software Recommendations:

_______________________________________________
🎓Data Course Suggestions: (coursera)

_______________________________________________
🎓AI Course Suggestions: (coursera)

_______________________________________________

🖥️ Office items I can't live without:

📲 Find me
_______________________________________________

⌚Chapter Time Markers:

00:00:00 - Intro
00:00:30 - Subscribe!
00:00:41 - The Data
00:01:29 - The Search Bar
00:01:42 - Query Solution
00:02:47 - Case Sensitivity
00:04:07 - Filter Solution
00:04:58 - Query with Multiple Conditions
00:05:40 - Filter with Multiple Conditions
00:06:26 - Which is Better? Query or Filter?

=============================
#googlesheets #spreadsheets #dataanalytics

[ethanrud]

Upon looking into this further this helped greatly, but if you were to convert your search box to lower case in your formula it would not matter about case sensitivity using &LOWER(J2)& in your formula: " =IF(ISBLANK(J2, "", QUERY(Transactions, "SELECT A, B, C, D, E WHERE LOWER(B) CONTAINS '"&LOWER(C1)&"''")) "

[ChrissiesPurpleLibrary]

Eamonn this was amazing! So easy explained and understood. Thank you so much!

[wandawonderer]

I really needed this, its such a great help! ❤️

[coghilla]

Awesome. the query version worked so much better than filter for my application. I have a spreadsheet that contains information about numerous vehicles (asset ID, location name, location number, location history, plus vehicle data of chassis, builder, useage catagory.. its huge over 1500 rows). I was able to get the search working for text data but other data ie numbers didnt work.

[silvestrecamposano]

Thank you very much for the explanation!....

[jwright]

If anyone else is getting stuck on how he has Transactions as a searchable area, I believe he's made the selected areas a named range.

[sharonroy]

This is great! Can you please show me how to use query and not lose hyperlinks in the process?

[mromeroh]

Hiii, thank you! I saw this in my workmate's sheet a few years ago and now that I need it, I was struggling on how to use it. 
I have a question, is it possible to have multiple criteria in the search bar and/or have different search bars to filter the query outcome. My use case: I have a data base for rental listings, with your help I can already use the search bar to filter out by condo name, I want to take it further and be able to filter it by number of bedrooms for example (and more).
It's basically like using the filter-click on a table but a more user-friendly way.
Thanks in advanced hope this is possible.

[nicolasdelrio]

this is really cool, thanks for the help

[Amanda-zzjq]

Is there a way to use the query function to search for things containing text anywhere in the cell or does this only work when the text is in order?
ie if the value is "Jackson's Meat Deli" but you search "Jackson's Deli" can you have the value return?

[smxojjk]

I have a question, what if for isblank you want to display all data? how would you do it? here is my current code =IF(ISBLANK(B1), " ", QUERY('Inventory quantity'!A4:N, "select * WHERE LOWER(B) CONTAINS '"&B1&"'", 1)) -- BTW great video!

[OSCARPION]

What if you have multiple tabs and want to search and a result from any other tab? Example: FINANCE, INVENTORY, VENDORS. Could you provide the Query method ?
thank you.

[RIForg]

Hi, I would like to add question to this if possible.
Say the thing I'm searching is in a merged cell, I would like the whole row to appear in the search result. It's not a uniform number of cells high, but there is a cell row as a gap in between each subject.
What would you suggest?

[misbakhan]

Does anyone know if I have a bookings spreadsheet for a set of workers. Id like a search or filter function that shows where they work quickly.

They can work at multiple locations.

Anyone know the best method at all please?

[kamilserwa]

I really like the idea of this search box and been trying to add this to my Sheet, some columns in my sheet are drop down selection columns and its only showing DATA from ABCD and (E) is drop down and wont show anything else past column D, anyway to use this still or this dont work with drop down columns.

Thank you!

[TRYING-gebr]

I WAS ALSO WONDERING IF I CAN USE THIS QUERY IF THER MAIN DATABASE IS FROM ANOTHER WORKBOOK, SO THE ONLY CONTENT OF THE SEARCH BOX SHEET IS THE SEARCHBOX AND SOME LABELS

[jblmnqs]

If a user has View access only, can they still use this dynamic search bar?

[sehrishali]

Hello Sir, can you please make a video on the query and import range formula using the search box with a search button in different google sheets.

[jneidlf]

is it possible to add other criteria to query search? More than one column?

[dukeagle]

Can you share the practice file, so we can see the formulas more clearly.