Forum Discussion

ntstestteam's avatar
New Contributor
2 years ago

Get Excel Row Index for a given String

Hi Team,


Could you please guide me to search for a String in Excel Sheet and get the Index/ address of that Cell. 


For ex: In the below Excel Table, i need to search for "Fruit_ID_2" in PrimaryKey Column and get the Row Index for it. 



Row1     Fruit_ID_1_______Orange

Row2    Fruit_ID_2______Kiwi