Google Sheet - Make your own Search Box (Data from Multiple Sheet)

Simple way to create a search box and filter the list/ data automatically in your google sheets.

***OTHER TUTORIALS FOR GOOGLE SHEETS***

Google Sheets - Search by Date Range

Google Sheets - Auto Update Options

Google Sheets - How to Highlight Row Based on Cell Value (Very Easy! Must Watch)

Google Sheets Print Unique Values Except Blank Cells (Made it Easy)

#googlesheets

#googlespreasheets
#spreadsheets
#excel
#tutorial
#googlesheetstutorial

#searchbox
#userinput
#sheets
#query
#search
#formula

[codingcoding]

This is really helpful, but what if there are 3 or more google sheet?

[wshstudio]

very good want this formula now i am very glad to find it

[ivanchan]

Wonderful! Can I know if I want the information that appears below after typing 'APPLE' in the search bar to be non-APPLE information? I'll really appreciate if you could help to solve this problem. Thanks.

[heatherenjun]

hi! can u help me, pls? :( i have a home page tracker that would search on 4 different sheets but all in one worksheet. i tried following the formula u provided to others who commented but it only read the first sheet >< how do i make it search in all 4 sheets? can u provide the formula if you don't mind :(( thank you so much this is such a life saveeer!

[christinejoydychangco]

Hi, is there a way to not show the data from the other sheet when there's no text in the searchbar?

[JerryE.RiveraJr]

Very helpful formula. What if I have search value with upper and lower case letter?

[marksawesomeadventures]

I wanted to post an Update on my Progress, I WAS finally able to figure this out, I wanted to talk about the mistakes I was making in case anyone else had these Problems. The first mistake I was making was trying to write the Formula Inside the same Cell as the Search Box. This won't work. You have to write the Formula in the Cell you want the Data to start Displaying. The Second mistake I was making was Writing the Formula ABOVE the Search Box, that won't work either. I figured this out by first practicing making Drop Down Lists and the Formulas for that is almost the same, then I just simplified it and instead of using the Drop Down list I used a Search Box, and behold IT WORKED! :D
This is the Formula I used in a Cell Below the Header Row where I wanted the data to display;
=QUERY(MASTER1!A2:I, "SELECT * WHERE A = ('"&A2&"')")

[ukproductstz]

I have input the formula but when i go to press enter the formula turns into text. What can I do?

[NiickNicholas]

Kinda sucks .. followed from your old video to this and still couldn't get it working .. im not sure what's wrong.. I've followed exactly

=QUERY(IMPORTRANGE("1k9x2d1yhKI7I8Jpb_0H6zz0dfyqD196s6-4_kcsBgYQ", "ITEM-LIST!A2:B10"), "SELECT * WHERE Col1 LIKE ' "&UPPER(D1)&" ' OR WHERE Col2 LIKE ' "&UPPER(D1)" ' " )

and it still shows ERROR

[marksawesomeadventures]

I am narrowing down my Confusion on this, so according to this Example I have to use Two Separate inventory Sheets? And in your Example you added data to one Sheet and it was Searched, but does this automatically add the data to the 2nd Data Sheet? So to be Clear you are using a Total of 3 Sheet? One Master list, One Duplicate Data List, and One Search Sheet Correct? And again if this is True how does the 2nd Data sheet get updated when I add to the Master List?

[ankitbhutada]

Haveing issue when applying error #value (unable to parse string for function query parameter 2:no_column1)

[yhopxfg]

Hello!!! Would this work for multiple sheets in one SpreedSheet?

[bxndage]

I'm having some troubles, I try to search data in two sheets from the same origin spreadsheeet, and it works for the first sheet, but shows nothing from the second sheet. Would you please help me?

[josephtactac]

What if I have 21 columns? is there any way to shorten the script? Thank you

[producciontogaslupita]

What if in my IDs I have numbers and letters? For example: 324CB4172ba2. I try taking the letters and it works. Is there a solution to have both numbers and letters in the IDs?? Thanks

[Aventurine_ven]

i had an question! Is it possible to search result out image instead of words?

[xygy]

What if I have multiple sheets in 1 spreadsheet how do I declare them in the code?

[rainieee]

It’s not working for me :( only row 2 is showing even though I havent search anything yet. I tried your other tutorial where it’s not case sensitive and only 1 col search and that works for me. I want to able to search on 3 columns. Doesnt matter if it’s case sensitive or not.

This is what I tried =QUERY(IMPORTRANGE("XXX", "Sheet2!A3:E"), "SELECT * WHERE Col2 LIKE '"&UPPER(G3)&"' OR Col3 LIKE '"&UPPER(G3)&"' OR Col4 LIKE '"&UPPER(G3)&"' ")

[kerwinestolonio]

The tutorial was very helpful. Thank you.. But when I select the Col6 (which is the list of names) onwards, it will not display. Do you have any idea how to fix it?

[sirmacademy]

Please more tutorials on query function. I learn a lot from you