How to Make a Search Box in Google Sheets | Search with Keywords (No More Exact Matches!)
#googlesheets #googlesheetstutorial #googlesheetstutorials #keywordsearch #searchbox
In a dataset in Google Sheets, you can make a search by using FILTER function. However, it has a limitation, which is the keyword should match with the cell contents thoroughly.
In order to make a search like searching with a keyword or a tag, you can integrate SEARCH function with FILTER. So, instead of searching for an entire text, you can search for a text string.
In this video, we will cover how to make a search box in Google Sheets. And we will be able to conduct a search with keywords just like we do at Google.
For more tips and tricks like these, please remember to subscribe to our channel and hit the bell icon to be notified whenever a new video is uploaded.
/ @clickbeyondsheets
Chapters
0:00 Intro
3:09 Using FILTER function
6:20 Using SEARCH function to integrate with FILTER function to filter out the data
10:00 Extending the Search availability to all columns in a dataset
10:17 Explaining "AND" and "OR" arguments as a logical operator used in extending the search availability
17:30 Using FIND function instead of SEARCH function