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 ♥
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.
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
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 👍🏻👍🏻👍🏻👍🏻👍🏻
@Ömer Faruk Akkaya @21:12 see the AND after JOIN! ... change the AND to be OR, so by this the query will turn the results to anything that contains any of the words/letters you put in your search criteria. if you put DRESS BABY it will show you any results containing ANY of these two words and not necessarily containing both, hope it cleared for you ;)
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.
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! 🙂
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
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 ?
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?
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
Thanks for the video, it help me alot. I have a question, if these sheet used by one user it look seem working allright. but, how if there is some users want to use those sheet at the same time? anyone will be interupt by one and another person while working. Do you have any alternative for it? thanks before.
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?
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.
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
Thank you! Is there a way to lock the search box so that when one person enters a search it does not filter down the data for other users looking at the sheet?
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. Thank you so much. It will be helpeful for me. Please, I would like to know if it is possible to do it using Contains instead of Like command (I will try to do it later) and if it is possíble search in more colums using an a interval as B2:H inside the command Contais lower () - now I am using Contains repeating the command using OR for each colum I want to search in. Thanks.
Is there a way to have the query function, pull from two or even three different columns in seperate search cells? So example I want to search the Location Column (E column), The Job Column (F Column), the Availability Column (G column), and I want each Search (location, Job, Availability) to be in their own separate search cells as drop down lists. So in Cell A5 is drop down search function for Location, in B5 is Drop down Search Function for Job, and C5 is Drop Down Search for Availability. I want to give the searcher several options on how to find the Artists that fits either one or search parameters.
You can try something like this (where A1=1st dropdown and A2=2nd dropdown). QUERY('Raw Data'!A1:E, "select * Where A is not null "&"IF(A1="AllResults",""," AND Lower(A) = Lower('"&A1&"') ")&IF(A2="AllResults",""," AND Lower(B) = Lower('"&A2&"')"),1,)
Found Simpler solution based on AND Statements =QUERY(Your Data Range,"SELECT * WHERE E LIKE ""%"&A1&"%"" AND F LIKE ""%"&A2&"%"" AND G LIKE ""%"&A3&"%""",1). Also, you can supplement those ANDs with ORs so that you don't get blanks/errors.
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. 🤔
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.
It only imports the value. You can specify what format you want for the output, but it's not going to pick up the original formatting. Watch my QUERY function series for more details.
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?
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.
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?
Thank you for this... For some reason the formula isn't working on numbers though? I have a column with numbers and fractions to search but it only give me the header when I search with this code. Is there anything I need to add to get this to sync with numbers and fractions?
Sure. Just make a VLOOKUP with a helper table that maps the column selection to column letter and use it in your select statement. Or at least that's one way :)
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 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?
HI at timeline 3:06 how do you make this query formula case insensitive? I type a lowercase but the data source are all caps so it did not show anything. when I type all uppercase, then I will have a result
How would I be able to display results if my search contains quotations? Eg. _____ I want to search for: 3" Screws ______ Result: # VALUE I followed your instruction at 3:54 and it worked for all my searches containing an apostrophe (eg. 9' Pipe), however it will not work with quotations...is there a solution?
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
Both If and Indirect will do the trick (+ filtering of null values), e.g query(Indirect(*here comes drop-down with sheet names*&"!"Range") or QUERY(INDIRECT(A2&"!A2:D"),"select *",1).
Just wonder for like i want to search by either description of products or the code of the product. How do i modify the query? Because for the description of the products work fine for me. But I want to improve it by search by the code. Really appreciate for the answers.
@@ExcelGoogleSheets I have the same question. For example: the code for the product is something like this: “12345abc678de” with no space between it. But I only want to type just the first 5 or 8 letters in the search cell and the query will show the results of all the closest ones that match the first 5 or 8 letters from the code of the product. Thank you so much.
Perhaps one of you folks may know, is there a way to perform this sort of query, but be able to change the column being queried? In this example, it's always referencing column E, but is there a way to have that E switch over to B or C and use the same typeable text field to search multiple categories?
this is a very helpful and useful video but i have more question. Is it possible to do Query with Number bc i tried to do the same as you teach but it doesnt work for me . please help thank you :)
How do you have this search box search through 2 different Columns for the same word(s)? Keep the same layout as you see in this video but it will search thought Column D and Column E for "baby Dress toddler" Thanks!
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?
🙏 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?
I wasn't able to find anything. If anyone knows I'm interested too. That being said you could use SUBSTITUTE function to replace double quotes in your data with double double quotes and then it would work like escape.
Learn Google Spreadsheets Thanks. I was thinking of maybe using SUBSTITUTE ‘ for its CHAR equivalent to avoid the problem with content, but I have yet to try it.
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, Thank you. How if we want to search for multi column? Example: for the Category is "Skirt" and Region is "Midwest". Is it possible to use 2 search box?
Hi please badly needed help. I want to add cell where i can search for another column like C4 will search in column D, D2 will search in column H etc. How can i add in this function? Thank you
Is there a way to make a search box that filters as you type? So you don’t have to click out of the cell to see the result. I saw a video that Excel could do that.
If i have a database with some information, and i work totally on a new sheet. For example, if i write: (A) name, (B) surname, (C) phone, (D) email, how can I get on (E) confirmation that already exists?
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!
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!
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.
Your method of teaching makes everything look easy, you're my most important resource of learning google sheets, thank you so much !
Your help has been invaluable. Thank you
Thank You!
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 ♥
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.
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
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 👍🏻👍🏻👍🏻👍🏻👍🏻
@Ömer Faruk Akkaya @21:12 see the AND after JOIN! ... change the AND to be OR, so by this the query will turn the results to anything that contains any of the words/letters you put in your search criteria. if you put DRESS BABY it will show you any results containing ANY of these two words and not necessarily containing both, hope it cleared for you ;)
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.
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! 🙂
very much informative. ecplained so well.nice tutorial. thanks
THANKS! I've been through many of your videos looking for something like this.. Really Helpful
Thanks so much for this very instructive video..more power to help us newbie out here!!
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
the function query is good, I like it! and thank you so much for sharing this easy function.
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 ?
VERY VERY USEFUL VIDEO, THANKS
Great! In a drop-down can you allow multiple selections instead of only one?
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)
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?
Yeah. I have the same question. How can you have all the options show when the field is blank?
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?
Wow, this is great. A million thanks. Please, supposing you want to generate a cost for two different items, how do you go about??
Very useful ! Thanks a lot you are very competent
Glad it was helpful!
Learn Google Spreadsheets thanks a lot, great video and very useful for my work
This is spectacular, simply Amazing!!!!!!! Thank you!!!!!
Greetings from Colombia friend
this helped me find the solution in the first few seconds of the video.
thanks
Excellent!
MIN 00:00 SEARCH ONE; MIN 07:49 SEARCH CONTAINS; MIN 10:21 SEARCH CONTAINS WORDS; MIN 14:03 SEARCH COTAINS multiple WORDS; min
Very Nice 👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍
Thank You!
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
Perfect video i have ever seen
Thankyou so much
Thanks for the video, it help me alot.
I have a question,
if these sheet used by one user it look seem working allright.
but, how if there is some users want to use those sheet at the same time? anyone will be interupt by one and another person while working.
Do you have any alternative for it? thanks before.
Thanks for clear explanation. You are wonderful tutor.
Very informative
Thank you
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 helpful and informative! thank you so much!!!
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.
Thank you so much for this tutorial.
Glad it was helpful!
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 tutorial sir. you are great sir thanks..
Thank you! Is there a way to lock the search box so that when one person enters a search it does not filter down the data for other users looking at the sheet?
No, but you should be able to user FILTER VIEWS to get something similar to what you want.
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?
Because when Im using this code for searching number it didn't shown up the data
Hi. Thank you so much. It will be helpeful for me. Please, I would like to know if it is possible to do it using Contains instead of Like command (I will try to do it later) and if it is possíble search in more colums using an a interval as B2:H inside the command Contais lower () - now I am using Contains repeating the command using OR for each colum I want to search in. Thanks.
Thank you for all your hard work generating this great content!
Congrats for your channel ... it is helping me a lot ... keep the great job man !
This was exactly what I was looking for Thank you for share this tutorial
Thanks for watching 👍
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
Is there a way to have the query function, pull from two or even three different columns in seperate search cells? So example I want to search the Location Column (E column), The Job Column (F Column), the Availability Column (G column), and I want each Search (location, Job, Availability) to be in their own separate search cells as drop down lists. So in Cell A5 is drop down search function for Location, in B5 is Drop down Search Function for Job, and C5 is Drop Down Search for Availability. I want to give the searcher several options on how to find the Artists that fits either one or search parameters.
You can try something like this (where A1=1st dropdown and A2=2nd dropdown). QUERY('Raw Data'!A1:E, "select * Where A is not null "&"IF(A1="AllResults",""," AND Lower(A) = Lower('"&A1&"') ")&IF(A2="AllResults",""," AND Lower(B) = Lower('"&A2&"')"),1,)
Found Simpler solution based on AND Statements =QUERY(Your Data Range,"SELECT * WHERE E LIKE ""%"&A1&"%"" AND F LIKE ""%"&A2&"%"" AND G LIKE ""%"&A3&"%""",1). Also, you can supplement those ANDs with ORs so that you don't get blanks/errors.
@@marcobanderas3306 Hello, can I ask you questions?
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. 🤔
There's anyway to make the results of the search to carry the text formatting used in the data?
Awesome tutorial.
Can I do the search on the whole array instead of just one column?
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.
It only imports the value. You can specify what format you want for the output, but it's not going to pick up the original formatting. Watch my QUERY function series for more details.
@@ExcelGoogleSheets Thank you, I'll check whole series !!
again.... you are "THE" SOLUTION....
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?
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.
Exactly what I was looking for! Thanks man
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?
Thank you for this... For some reason the formula isn't working on numbers though? I have a column with numbers and fractions to search but it only give me the header when I search with this code. Is there anything I need to add to get this to sync with numbers and fractions?
Just delete the word 'Lower'
The last part was so good! Thanks, man. Is it possible to make it more dynamic? Like selecting the column we wanna search?
Sure. Just make a VLOOKUP with a helper table that maps the column selection to column letter and use it in your select statement. Or at least that's one way :)
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
The Real MVP
This man needs to get pray for his kindness
What would the query be to search multiple tabs/sheets?
Awesome tutorial! Is there any way we can edit the searched results? So that it reflects the original sheet
No, not formula results.
Love it! Thanks bro! This is so good!
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?
HI at timeline 3:06 how do you make this query formula case insensitive? I type a lowercase but the data source are all caps so it did not show anything. when I type all uppercase, then I will have a result
How would I be able to display results if my search contains quotations?
Eg.
_____
I want to search for:
3" Screws
______
Result:
# VALUE
I followed your instruction at 3:54 and it worked for all my searches containing an apostrophe (eg. 9' Pipe), however it will not work with quotations...is there a solution?
Doubling quotes usually escapes them, So I would try to to wrap the reference in SUBSTITUTE(A1,"""","""""") and see if that works.
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!!!
Sir U are great person
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
Both If and Indirect will do the trick (+ filtering of null values), e.g query(Indirect(*here comes drop-down with sheet names*&"!"Range") or QUERY(INDIRECT(A2&"!A2:D"),"select *",1).
Your video is excellent but can you please share the sample file too so that it gets easier to along ?
=QUERY(data,"SELECT * WHERE 1=1 “&”AND LOWER(E)LIKE LOWER(“”%” &JOIN(“%””) AND LOWER(E)LIKE LOWER(“”%”, SPLIT(B1,””))&”%“”)”,1)
very helpful, thanks
Just wonder for like i want to search by either description of products or the code of the product. How do i modify the query?
Because for the description of the products work fine for me. But I want to improve it by search by the code.
Really appreciate for the answers.
Use or statement,
More info here ruclips.net/p/PLv9Pf9aNgemvAMlqvHP9RhXPW98g_eo7d
@@ExcelGoogleSheets I have the same question.
For example: the code for the product is something like this: “12345abc678de” with no space between it.
But I only want to type just the first 5 or 8 letters in the search cell and the query will show the results of all the closest ones that match the first 5 or 8 letters from the code of the product.
Thank you so much.
Again, all of what you're asking is covered in the playlist of QUERY function.
Perhaps one of you folks may know, is there a way to perform this sort of query, but be able to change the column being queried? In this example, it's always referencing column E, but is there a way to have that E switch over to B or C and use the same typeable text field to search multiple categories?
The short answer is yes, it's possible.
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
this is a very helpful and useful video but i have more question. Is it possible to do Query with Number bc i tried to do the same as you teach but it doesnt work for me . please help
thank you :)
Same here
Will this work even if the person is only a "Viewer" on the sheets?
No, they won't be able to type in the cell.
Thank you soo much! You are a life saver :)
How do you have this search box search through 2 different Columns for the same word(s)? Keep the same layout as you see in this video but it will search thought Column D and Column E for "baby Dress toddler" Thanks!
How did you add the keymoments like that in the description?
thanks for the video .really appreciate your help
Excellent ! Very useful.
I Love You So Much
Hello, will the query works if data are in different sheets?
What do you mean by "sheets"?
@@ExcelGoogleSheets what I mean is, how can use this function where data range are on different sheets.
Worksheets or Workbooks?
For worksheets, just select the data from the other sheets. The rest is exactly the same.
For workbooks watch this ruclips.net/video/_N5zhAipVn0/видео.html
@@ExcelGoogleSheets how will I do that?
Hey, would it be possible to have 2 queries? Like in different sheet?
Can you make a test bank alike in excel then have the same idea of searching bar when you input a phrase of the question?
Yes you can
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?
13:14 nice tuba sound ❤️
🙏 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?
I wasn't able to find anything. If anyone knows I'm interested too. That being said you could use SUBSTITUTE function to replace double quotes in your data with double double quotes and then it would work like escape.
Learn Google Spreadsheets Thanks. I was thinking of maybe using SUBSTITUTE ‘ for its CHAR equivalent to avoid the problem with content, but I have yet to try it.
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, Thank you. How if we want to search for multi column? Example: for the Category is "Skirt" and Region is "Midwest". Is it possible to use 2 search box?
ruclips.net/video/nLW8SerwnJo/видео.html
I am using IMPORTHTML but the Query isn't reading the table I pulled in. Is there a workaround?
Use FILTER function
Good job 👍
i have used this and thank you for this video
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?
Wrap JOIN(...) with ISERROR(JOIN(...), "")
Hi please badly needed help. I want to add cell where i can search for another column like C4 will search in column D, D2 will search in column H etc. How can i add in this function? Thank you
Is there a way to make a search box that filters as you type? So you don’t have to click out of the cell to see the result. I saw a video that Excel could do that.
You can only do it if you use some sort of web interface, like in this example ruclips.net/p/PLv9Pf9aNgemvM36efLpaHxbkZTGp2pfhx
@@ExcelGoogleSheets Ok cool. Thank you.
If i have a database with some information, and i work totally on a new sheet. For example, if i write: (A) name, (B) surname, (C) phone, (D) email, how can I get on (E) confirmation that already exists?
is it possible to limit the result to only certain column instead?
Thanks bro, big help!
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!
When you search for numbers you don't need to put the value in single quotes. So for example:
WHERE A = 'Keyword'
WHERE A = 4
As always absolutely fantastic
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!
Is it Possible to have the search go over multiple inventory tabs?