Google Sheets - Search, QUERY function

Learn how to create search box in Google Sheets using QUERY function. We'll create basic search for exact match, then search for text that contains the query and finally create a search that will find matches to multiple words in any order.

#googlesheets #search

[ParthaDas-wyps]

I've been doing this search problem for two days now, and finally, after watching your video, I found a solution to my problem.Thank You Sir.

[malikastar]

Your method of teaching makes everything look easy, you're my most important resource of learning google sheets, thank you so much !

[angrybobr]

At the beginning of the video, I was looking at it and thinking: "Oh...boring, every newbie knows that"... but later, close to the end... the only words in my head were: "What a tricky mo***fu***, u got me!"

Big thanx for that tutorial.

[uncertainAuthor]

This was exactly what I was looking for to try and put a search function into a spreadsheet I've been working on! Thank you so much for sharing this easy to follow and informative tutorial ♥

[dfilliernl]

Fantastic tutorial ... you just saved me and my team a ~huge~ amount of time and effort.

Thanks for taking the time to produce and share this tutorial.

[Azzzs]

Love it how implanted the split them join to create such a loop! Amazing idea, more to it I've adjusted the AND to OR too show all data in single words, thanks a lot, gonna be watching more and more of your vids to learm more too, never thought SQL could be such fun and amazing language and excitingly challenging to use to help me out big time with my needs 👍🏻👍🏻👍🏻👍🏻👍🏻

[bobykumar]

again.... you are "THE" SOLUTION....

[jerikhodejesus]

thank you so much for sharing. I just want to ask to you if what is your advise to control the simultaneous flashing of result from the query using the QUERY ONE function when the google sheet users had type their own searching data in the search box at the same time? Thank you very much

[arnellcarmichael]

Absolutely brilliant tutorial my guy! Very easy to follow, and educational! Thanks for putting this video together, and it definitely helped me save time searching data within my CRM! Best - Arnell

[tahanawfal]

to make it search for multi columns:
_=QUERY(data, "SELECT * WHERE D LIKE ""%"&B2&"%"" AND (C LIKE ""%"&B3&"%"" OR B LIKE ""%"&B3&"%"") ", 1)_
notice that AND & OR are logic gates and you should change between them if there is no result

[iftaminka]

I did this tutorial and it's amazingly help me completed my final task, Thanks!
But I've no idea how to create this when I've few different data in multiple sheets, looking for it

[nikhilgala]

very much informative. ecplained so well.nice tutorial. thanks

[monicamusial]

This is a great tool and you explained it very well! Thank you!! I just have a question. Is there a way for the search results to be blank when the search drop-down is empty?

[andresleon]

THANKS! I've been through many of your videos looking for something like this.. Really Helpful

[arielzabatecuizon]

Thanks so much for this very instructive video..more power to help us newbie out here!!

[Allen-L-Canada]

Great! In a drop-down can you allow multiple selections instead of only one?

[selvarajandiappa]

Thanks, very helpful. Following most of your tutoring.. Just want to find out why after search result when you edit any data, all search data disappears and the formula reruns errer

[manicare]

Really nice for me to get it resolved my issue but same thing how can i do it for multiple sheet to fetch the same result

[amoeudaemonic]

Thank you for the tutorial! Easy to follow, but I also learned some functions of formulas as well! We created a searchable database of flavors and nicotine strengths for our vape store with this. You've given my workers a nice cheat sheet for sure! Thanks again! 🙂

[jonayego]

Wow, this is great. A million thanks. Please, supposing you want to generate a cost for two different items, how do you go about??