Google Sheets - Build Your Own Search Box

Create a search box that takes user input and highlights the rows where the word or number is found in the data.

🕒 Timestamps:
0:00 Intro
0:45 SEARCH Function
2:30 Make the Input Box
2:58 Conditional Formatting

Learn more from Prolific Oaktree:

#googleseets #spreadsheet #tutorial

[xoterra_space]

Thank you for very helpful video!
But what should I do if I want to leave the cell not in highlight when search box is empty?

[saasaaluv]

thanks for the guideline! Its very easy to understand and helpful

[Maidenas]

Hello !! That is perfect well done ! How can we change, when the SearchBox is empty not to highlight everyting ?

[VanessaSandoval-pi]

Hi, This is perfect thank you, is there anyway to get rid of the extra highlighting when there isn't anything in the search box?

[AdithyaShreshti]

This is brilliant, can we do something like this to find different tabs available in one google sheet?

I don’t want to get into searching the content in each tabs though

[goombah_]

Is there any way to make data appear un-highlighted until the search function is used?

[jonlawrance]

Great video, helped me create a search box that works so thanks! The only problem now is that I have a large sheet with thousands of entries and the search doesn't automatically scroll down to the result so I'm scrolling manually looking for the highlighted item. How can I make it scroll to the result automatically?

[vianca]

Thanks for this!! It's very clear and easy to follow!

[JDeWittDIY]

Thanks for the video, works great! Is it possible to hide rows that do not match the search text?

[jjable]

Hi sir. Thank you for the tutorial. Have one doubt. Can you plz tell how to search multiple text or number in the search box?

[sakmberjoshi]

THANK YOU SO MUCH SIR REALLY THANKFUL FOR THE INFORMATION !

[readingdays]

Hey! I'm trying to make a search bar for a homemade book catalog. Every time I do this though only some bars gets highlighted, and when I search it gives me a book two bars above the actual thing I am searching for. Is there a way to fix this?

[daklaker]

Thank you master!! Would you pls show me how to indicating just only row having data that we search, so how could i do that? Thank you!!

[ianmccusker]

Hi Adam, Enjoyed the tutorial thanks. I'm not a coder or anything but I was trying to create a search box facility on my website (like google search) that using Google Sheets could link to an external website that will have over 400 pages. The way I want it to work is the person would type their name in the box and if it was on the Google sheet it would appear in the box and once they clicked on it it would take them to that particular web page. Just wondered if you were able to point me in the direction of where I can find a video where someone explains how to do this. Thanks for your help in advance.

[OurTayloredHome]

Thanks for the video. Very helpful. How would I need to change the formula if I wanted to search the text of multiple columns instead of just one like in this example?

[splatterdaynightmares]

Is there a way to do all of this by creating a front end using Google forms? I'm trying to find a cheap, decent database that has a great front end but nothing compares to filemakre pro. I tried the form but it only lets me back in with a link or the spreadsheet itself which is quite infuriating because I'm not sending it to others, it's only for myself. Thanks

[brazzilianboy]

Great content, but I have one question, there is any way to put some text placeholder like "type to search" in the search box?

[-oe]

Hello. This is very helpful!! Can we also search for data from a range of cells ? ex. C2 to M1000

[nature_through_my_lens]

Can I add this search box on my google site and it directly shows the result based on the conditional formatting?

[claudiacolati]

Hi! Love the videos, they are super helpful!

I am currently having difficulty with texts moving from their spot whenever I write something above it on Google docs. I have currently began writing a novel and made a table of contents with bookmarks and links to go along with it (with the help of your videos!). I have placed this table of contents as the first page to the document, which will be regularly updated as I write new chapters and add each one to the table of contents. My problem is that because the TOC starts as the first page and the "first page" to chapter 1 starts on the next page, how do I prevent that first page of chapter 1 from moving down every time I add to the TOC? I've tried searching the internet, mostly people suggesting I do a page break, but every time I try using it, it just doesn't seem to work for me (I'm probably just doing it wrong).

Thanks in advance for the advice!