# Search more than one column in a Google Sheet

**URL:** <https://community.thunkable.com/t/search-more-than-one-column-in-a-google-sheet/1767733>\
**Category:** Questions about Thunkable X\
**Tags:** beginner\
**Created:** [March 4, 2022, 8:40pm UTC](https://community.thunkable.com/t/search-more-than-one-column-in-a-google-sheet/1767733 "2022-03-04T20:40:52Z")\
**Posts on this page:** 1\
**Showing post:** 12

<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:** [March 5, 2022, 5:11pm UTC](https://community.thunkable.com/t/search-more-than-one-column-in-a-google-sheet/1767733/12 "2022-03-05T17:11:42Z")

</div>

Continuing to discuss the issue, see this example

This is my data set in sheet1  
 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/b/c/bc60604856959464e1b3d0b9649e70dcfb9f85bc.png)

I go to another sheet (sheet2) and create the same columns with additional search column  
 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/4/54c3cb824defc3ca7d829e5f49129b2353bd9825.png)

In the first row and first column of the data enter this formula

```auto
=filter(Sheet1!A2:B7,Sheet1!A2:A7=C2)

```

This means that Google sheet will regenerate the list in **sheet2** that matches the text entered in the search column.

In Thunkable you can place a `Text Input` and update that row/column in Google sheet to get the filtered value which is mapped to the DVL (Data Viewer List) in your Thunkable screen.  
 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/f/ffb6ccad4a6d6780a8b0ee7e4f63777deafec8ed.png)

---

_[View the full topic](https://community.thunkable.com/t/search-more-than-one-column-in-a-google-sheet/1767733)._