Copy cell to another table

[TheBadOne]

Hello all. I need to copy in the Table1[Customer number] the row number of row in Table2 which contains the same [ID] as Table1 have.

In other words, I need to compare the [ID] of both tables and put in Table1 in cell [Customer number] the value of the row number of Table2, which contains the same ID as in Table1.

I am hope for your help, dear community.

[TeeSee1 · Accepted solution]

If this is a one time operation, you may want to do it directly on the database.

If you want to create an action, use a "set the values of some columns in this row" and pull the _RowNumber by 

LOOKUP(
 [_THISROW].[ID]
 "Table2",
 "ID",
 "_RowNumber"
)