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 
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
