# Product search from Google Sheets

**URL:** <https://community.thunkable.com/t/product-search-from-google-sheets/2093738>\
**Category:** Issues / Bugs\
**Tags:** beginner, search\
**Created:** [October 21, 2022, 6:00pm UTC](https://community.thunkable.com/t/product-search-from-google-sheets/2093738 "2022-10-21T18:00:47Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![doudy11508s](https://avatars.discourse-cdn.com/v4/letter/d/2bfe46/32.png) [@doudy11508s](https://community.thunkable.com/u/doudy11508s)\
**Post date:** [October 21, 2022, 6:00pm UTC](https://community.thunkable.com/t/product-search-from-google-sheets/2093738/1 "2022-10-21T18:00:47Z")

</div>

Hello friends  
I have several products with several columns in Google Sheets

I want to search by 2 keywords  
“name”  
“Catalog number”

As soon as I click the search button, it will show me the rest of the data found in Sheets (preferably it should show them with a label)

I tried to build some options with a search in the forum and I didn’t succeed  
Who can help?

---

<div class="post-metadata">

**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\
**Post date:** [October 21, 2022, 6:28pm UTC](https://community.thunkable.com/t/product-search-from-google-sheets/2093738/2 "2022-10-21T18:28:11Z")

</div>

I made a tutorial for such situations. See this

> [@Filter Google sheet Data and show the result in a DVL](https://community.thunkable.com/t/filter-google-sheet-data-and-show-the-result-in-a-dvl/1635841):
>
> Just wanted to share this trick to filter data in a DVL For Example, if I have a sheet with numbers and names then I need to add another column to be the condition to filter by [image] In this example I have a number column and a name column and the 3rd is the search column. In a separate sheet have the same two column headings [image] In the row immediately below the heading of the first column, enter this function =filter(Sheet1!A2:B7,Sheet1!A2:A7=Sheet1!C2) [image] Now in Thunkable, …

---

<div class="post-metadata">

**Author:** ![ioannis](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ioannis/32/146956_2.png) [@ioannis](https://community.thunkable.com/u/ioannis)\
**Post date:** [November 8, 2024, 1:12pm UTC](https://community.thunkable.com/t/product-search-from-google-sheets/2093738/3 "2024-11-08T13:12:46Z")

</div>


