Compare value and get row.index

Beginners
1

Hello people!

Maybe very simple question but I am a bit stuck there:
How to call the row.index of a table by comparing 2 table’s value ?
I want to compare value here (which is “Cross”) and get the position in the table.

33
331116×1286 41.8 KB

Thanks !

1 Like
2

I have same problem.
Bump!

3

Hello,
If the searched string is in the first column (as you do), you can add a second column numbered from 1.
You can write
numberedItem = op(‘GEO_TABLE’)[‘Cross’,1]

10
10538×540 13.5 KB

4

and a more precise and elegant method:

search = op (‘table1’).findCells (‘Cross’)
search = str(search)
a = search.find (‘cell’)
b = search.find (‘,’)
row = int(test [a+6:b]