FINDING POSITION OF A CERTAIN DATA

[Uk]

Hi masters, 

I have two tables

table 1 is named SEARCH

table 2 is named CODE

From table SEARCH, I want to know in what row number of 1005980985 (yellow line) is located

I just tried this formula, but i didn't work COUNT(CONTAINS(code[id]), [id] = [_THISROW].[id]))

The following image is CODE table

any idea? thanks

[Marc_Dillon]

https://help.appsheet.com/en/articles/2357309-lookup

[Uk]

hi @Marc_Dillon thanks for it. But I mean I want to find out in what number of row it is. 

Row Number 1, 2, 3, stc.

Should I use COUNT formula?

[graham_howe]

There should be an automatically generated column in your table called _RowNumber, you don't need to calculate it. You can decide to show it or query it like any other column.