Creating a Powerful Advanced Search Box in Google Sheets - Step by Step

#google_sheets #googlesheetstutorial #googlesheets
In this TH-cam video, we will be showing you how to create an Advanced Search Box in Google Sheets with search and filter functions. We will be walking you through the steps of setting up the search box, adding the search and filter functions, and then testing it out. We will also provide tips on how to customize your search box for maximum efficiency. With this tutorial, you'll be able to quickly and easily create an Advanced Search Box in Google Sheets that can help you find exactly what you're looking for!
💡Timestamps
00:00 Intro
01:02 Creating search boxes
03:11 Formula
06:06 Test the boxes
06:40 Wrap Up
--------------------------------------------------------------------------------------------------
Formula: =If(and(Isblank(D3),Isblank(F3),Isblank(D4),Isblank(F4)),"",(filter((Database!A2:F),SEARCH(D3,Database!A2:A),SEARCH(F3,Database!B2:B),SEARCH(D4,Database!C2:C),SEARCH(F4,Database!F2:F))))
--------------------------------------------------------------------------------------------------
Spreadsheets Link
Link to the sheet
"Our website is under construction and will be ready soon. You'll find the sheet link there shortly!"
❤️❤️❤️
"Drop your email in the comments for an exclusive website launch notification. Thank you for your interest!"
---------------------------------------------------------------
❤️ Donation ❤️
--------------------------------------------------------------------------------
Subscribe link
/ @techtrickswitheli2023
Related Links and useful playlists
Google sheets playlist
• Google Sheets Tutorials
Google Forms playlist
• Google Form Tutorial

[@suzu_1848]

It took me for a day to work my sheet properly. Thank you so much for the instructions!❤

[@TechTrickswithEli2023]

❤❤❤

[@adekunleaderibigbe3119]

Great tutorial. Keep this up. I love the way you simplify the process

[@TechTrickswithEli2023]

Glad it was helpful❤

[@shafeekshefe8093]

Thanks its working great 🎉

[@therejane83]

Thank you!!! Very good video. You solved my problem!

[@TechTrickswithEli2023]

Glad it was helpful❤

[@jalalkia-gi8vl]

great . i saw your both google sheet and this video. excellent

[@jalalkia-gi8vl]

What's difference between crud and Google apps script

[@professional_typing]

Very good Eli, your video is clear enough 👌❤️

[@TechTrickswithEli2023]

Thank you 🤗

[@Makmaven]

Eli you did very well, very good presentation,I love it

[@TechTrickswithEli2023]

Glad it was helpful ❤

[@kctinternet]

Thanks for your help

[@TechTrickswithEli2023]

Happy to help

[@aakashchudasma6060]

very useful and superb explanation.

[@TechTrickswithEli2023]

Glad it was helpful❤

[@mustafaemrecam]

Usefull, thanks

[@TechTrickswithEli2023]

Glad it was helpful!

[@BibleStoriesinaminute-ry2ld]

Thanks a million

[@TechTrickswithEli2023]

🌹🌹🌹

[@oliwamick]

thanks for this great tutorial! i´ve got one problem, when looking for specific data - i´m looking for climbing routes in my database - for example 7a - but i receive 7a and 7a+ - how can i find 7a only? thanks!

[@Abstractmindzent]

How do you make this to grow with a sheet? Do i need to keep changing the columns range? I want to do this for a datasheet that has a growing addressbook on it.

[@ahmedal-afifi2101]

thx

[@TechTrickswithEli2023]

Your welcome🌹

[@gastonhitw720]

the formula works, but I have an issue, I have a lot of columns with data with some blank rows, for example from A to L i have data, but L to Z no data at all, then from Z to AZ I do have data, I have to move the sheet for a long time with other rows that go up to HZ, I would only like to display the data, not the blank cells, something like an autoamtic adjustment of the columns how can I fix that? in the same formula? or is there an option in google sheets?

[@shafeekshefe8093]

Hi
Can you help me
How can i make it different work book

[@AlphaVox]

Hi Eli, appreciate the work. Try to make a video on creating HTML form with dynamic drop-down fields for inventory booking. Fields 1. DATE 2. PO Number 3. INV/DN number 4 item Group. 5. Item code, 6.Item Description 7. PO Qty 8. Received Qty till date 9. Receiving qty 10. Balance Deliverable 11. BATCH 12. User Remarks. All quantities except point 9 can be output only gray fields.🎉

[@AlphaVox]

There will be a PO master sheet in the hiding to pull relevant data.
3 sheets total.
1. Form
2. DATASHEET
3. PO Master.
So po idea is when the user select a PO, except point 3,9 and 12 should be picked from the PO master and give the user only those option thats available under the PO selected

[@AlphaVox]

Any previous records of receipt of items with the same PO should be calculated and presented under points 7,8 and 10

[@AlphaVox]

Hope I have covered the specifics

[@organickrishi5679]

Please give a link google form projects where has a advance search option

[@tanyabowe7993]

What if I have 2 sheets of data?

[@mcsdds4100]

Hello. What is the formula for searching more than one database (sheet)?

[@TechTrickswithEli2023]

I will make a video for your question

[@AnkitRaj-ir9ys]

My formula getting error

[@Abstractmindzent]

mine too, it would only show the first entry on a2 and not other ones.

[@JoeyAbapo]

It doesn't work for me.... its an ERROR......

[@TechTrickswithEli2023]

Please Explain your error more

[@thailandlocal7828]

It's not work for me It's ERROR