# Getting a row number of cell containing a particular text

**URL:** https://community.thunkable.com/t/getting-a-row-number-of-cell-containing-a-particular-text/76233
**Category:** Questions about Thunkable X
**Created:** [May 13, 2019, 1:43pm UTC](https://community.thunkable.com/t/getting-a-row-number-of-cell-containing-a-particular-text/76233 "2019-05-13T13:43:52Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![kartik\_old](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/kartik_old/32/28305_2.png) [@kartik\_old](https://community.thunkable.com/u/kartik_old)
#### Post date: [May 13, 2019, 1:43pm UTC](https://community.thunkable.com/t/getting-a-row-number-of-cell-containing-a-particular-text/76233/1 "2019-05-13T13:43:52Z")

</div>

Hello,  
I want to get the Row Number of a particular cell containing a particular text…  
I used **for loop** to search the text. But I didn’t get my expected result…  
This is what I did 👇👇

 ![temp](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/b/fb0ac54863a9fd289126dd32f5b0cc11f5521be2.png)  
For getting the email, I need to input the full text present in the cell in the spreadsheet.  
**Example** : the cell in the sheet contains “Kartik”; My aim is : If user enters “Kart”, get the email of the cell containing text “Kart”…

Kartik

---

<div class="post-metadata">

### Author: ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)
#### Post date: [May 13, 2019, 2:09pm UTC](https://community.thunkable.com/t/getting-a-row-number-of-cell-containing-a-particular-text/76233/2 "2019-05-13T14:09:01Z")

</div>

Hello,

an example of searching and filtering data from AirTable can be viewed on the scrAirTable screen in the project:

[https://x.thunkable.com/projects/5cd84f23e3097f3353fdad45/project/properties/designer/](https://x.thunkable.com/projects/5cd84f23e3097f3353fdad45/project/properties/designer/)

---

<div class="post-metadata">

### Author: ![kartik\_old](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/kartik_old/32/28305_2.png) [@kartik\_old](https://community.thunkable.com/u/kartik_old)
#### Post date: [May 13, 2019, 3:29pm UTC](https://community.thunkable.com/t/getting-a-row-number-of-cell-containing-a-particular-text/76233/3 "2019-05-13T15:29:41Z")

</div>

OMG  
Thank you so much!  
You built such a great quick tutorial app from which any beginner can get help!  
This solved my above + many problems…😀😀  
Thanks a lot,  
Kartik

---

<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, 12:13pm UTC](https://community.thunkable.com/t/getting-a-row-number-of-cell-containing-a-particular-text/76233/4 "2024-11-08T12:13:45Z")

</div>