# 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:** 1

<div class="post-metadata">

**Author:** ![andos-avlog](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/andos-avlog/32/122340_2.png) [@andos-avlog](https://community.thunkable.com/u/andos-avlog)\
**Post date:** [March 4, 2022, 8:40pm UTC](https://community.thunkable.com/t/search-more-than-one-column-in-a-google-sheet/1767733/1 "2022-03-04T20:40:52Z")

</div>

Hi, I have been rummaging through the Community Topics without success.

What I would like to know is, is it possible to simultaneously search more than one column on a Google Sheet from a single Search box?

And if it is, how is this done?

**Example:**

Suppose I had a **Google Sheet Tab** containing **4 columns** of data, and let’s say, **10 rows/ records** and by typing text into the single **Search** box a **text string,** a list of records would containing that **text string** from any cell in the **Google Sheet Tab** would appear as a clickable list.

**Image**

![Dummy Screenshot](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/e/7eaef0aae7b6efe2b2a5fd2772a98c8ded937154.png)

If I typed in “ **Mr** ” my list results would contain: **Rob** ; **Tom** ; **Joe** ; **Tim** ; **Terry** ; **John** & **Bill** or,  
if I typed in “ **Rry** ” my results list would contain: **Jane** ; **Joe** ; **Terry** ; **Bill** & **Paula**.

If I were to click on any resulting names, I would be presented with that **full record of 4 columns**.

How would I begin to create this?

Andos.

---

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