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.

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 ♥

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

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.

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! 🙂

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

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 👍🏻👍🏻👍🏻👍🏻👍🏻

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

Thanks for clear explanation. You are wonderful tutor.

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

Great Job!!! Thank you so much!! I wanted to ask you to do something like this....but you had the Idea before I could ask!! Thanks!!!

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

Congrats for your channel ... it is helping me a lot ... keep the great job man !

Exactly what I was looking for! Thanks man

very helpful and informative! thank you so much!!!

Thank you for all your hard work generating this great content!

the function query is good, I like it! and thank you so much for sharing this easy function.

VERY VERY USEFUL VIDEO, THANKS

really nice tutorial sir. you are great sir thanks..

As always absolutely fantastic

Love it! Thanks bro! This is so good!

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.

Perfect video i have ever seen Thankyou so much

helpful content thank you !

This is awesome, just started using this. Wondering how to handle B2 being empty - split function doesn't like it. I'm trying to include ALL results in the query if B2 is blank?

Thanks bro, big help!

Excellent ! Very useful.

I Love You So Much

Thank you soo much! You are a life saver :)

thanks for the video .really appreciate your help

Good stuff! thank you so much :)

You're awesome, my friend

Thank You Sir from Cambodia and this help me a lot. would u mind create Query related to Bar Chart report or Graph Analysis in the next video? Thank You.

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

Very informative Thank you

Very useful class. You taught how to use query function with examples of region and reps. Can we have search option along with regions and sales reps. 🤔

i have used this and thank you for this video

The last part was so good! Thanks, man. Is it possible to make it more dynamic? Like selecting the column we wanna search?

Your help has been invaluable. Thank you

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

This is spectacular, simply Amazing!!!!!!! Thank you!!!!! Greetings from Colombia friend

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

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?

Thank for the tutorial

Thank you so much!

Good job 👍

Thank you SO much!

Thanks for the apostrophes info

This is genius!

This was exactly what I was looking for Thank you for share this tutorial

this helped me find the solution in the first few seconds of the video. thanks

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

Sir U are great person

Very usefull, thx

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

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

Thank you so much for this tutorial.

What would the query be to search multiple tabs/sheets?

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

Great video helped alot with me searching but I have a question how can I do this search to entire workbook or multiple worksheets? Can you please help?

Very useful ! Thanks a lot you are very competent

very helpful, thanks

Hello there. I have a long log of footage in spreadsheets. The scene descriptions are in cells that contain a significant amount of text and when I search for a word, I am always shown the whole cell, but not the word itself, which in my case is a bit of a problem. Is there a way to get a search result that is more detailed than just the cell where the particular text string is? This would be very helpful, thanks!

This was a great explanation. If I wanted to edit one of these records, how would I either edit it here and update the main sheet, or how would I like to that record so I could edit it in the main sheet?

Really thank you Buddy

Brilliant!

There's anyway to make the results of the search to carry the text formatting used in the data? Awesome tutorial.

how do you also pull through the hyperlink in the data sheet as well? So say your skirts has a hyperlink to open up a video and you need this hyperlink brought through so that you could click skirt and watch the video?

Hello, So I want to do a thing, when I search for example: an apple, it will check all the lists and when it finds the word apple, it will show it under the search bar (like in the video, but it will check all lists). Is that possible? Can you help me?

Thank you so much.

wow. . thank you

Very Nice 👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍

Thank you so much!!! you help us to work much easier ! May I ask if query function can also import both value and format? seem like it only import value not include format of that cell.

Genius!

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

Thank you so much

I love this tutorial, your tutorial is very great 🔥. I just using it to my data and it works, but I just confused and want to ask if i want to using this formula to search a unique code number from my list, is it using a same code? Or there's different code?

hi! in this case we can make the same cell to search in more in column A,B ,c...? ( 1 single cell can search by name, phone number or date)

thanks for this great video. Is there a way to make the search check different tabs on the form. I want to search data in column A on multiple tabs rather than just one tab. thank you

Thank you very much

Can I do the search on the whole array instead of just one column?

Awesome tutorial! Is there any way we can edit the searched results? So that it reflects the original sheet

Hello, this was very helpful but I was wondering how to do something. Is there a way to search for things in multiple columns at once?

Hey there, can i ask question? About your video? Is it possible that if i can and search function on specific sheet it can able to update the data also ?

NICE!!

In the "Search Contains Words" when there's nothing in the search field it comes up with #VALUE!. How do I get it to display everything like at 9:20?

Hey brother I loved this video, in the small chance you see this, what if there is typos? It seems to break the query thank you

awesome..

Greetings. I'm looking to query from a dropdown a data set that does not always exactly match the reference in the dropdown. I've tried CONTAINS, LIKE, wildcards (such as %), and it doesn't work. For example, my data would include "Kites Red", "Kites - Red", "Kites Blue", "Kites - Blue", etc. When the dropdown shows "Kites - Red", the "Kites Red" results do not appear. What query syntax can I use that will result in both "Kites - Red" and "Kites Red" showing as search results? Thanks.

I would like to be able to search from the Google Form Drop Down box. Is it possible? I want to be able to open the form, populated by a record from Excel spreadsheet I use for the form

Wow

Your video is excellent but can you please share the sample file too so that it gets easier to along ?

🙏 Very helpful seeing how to escape the content apostrophe with the double double-quotes. Is that the only practical way to handle that? In SQL, the content is escaped so that it won’t cause this problem. Is there a way to escape the content in Sheets query?

Thanks Very good

How would you Setup Google Sheets in an Index Card Platform?

🙌🏻

What if I want my selected columns to be two how would I type my formula

Can you Please add UNIQUE (or something) so that my Hyperlinks are returned intact and still function as hyperlinks? Queary returns them as useless data. Thanks for the great tutorials

Hi, I’ve used the following formula like yours in order for me to achieve what I need. So I have the data from the database sheet where in I get to find things on column D =QUERY(Database!$A:$T,”SELECT A,D,O,P,R,S WHERE 1=1 “&”AND LOWER (D) LIKE LOWER(‘%” &JOIN(“%’) AND LOWER (D) LIKE LOWER(‘%”,SPLIT(B1,” “))&”%’)”,1) Now, May I ask what can I do if I also want to search for data in Column A, those data contain numbers. What formula can I add to the above? Really appreciate every videos! Thank you!

Is it Possible to have the search go over multiple inventory tabs?