Last row value

[TheBadOne]

I have 2 tables ([Table1] and [Table2]). And I need to make a condition for bot event for table 1, provided that if in table 2 in the [Date] column in the last row [Date]=TODAY() and in the Table 1 in the column [ID]="123", then the condition is valid. Help me with syntax.

[AleksiAlkio · Accepted solution]

It should be something like.. AND(LOOKUP(MAXROW("Table2","_ROWNUMBER"),Table2,Key,Date)=TODAY(),[ID]="123")

[TheBadOne]

What is Key?

[AleksiAlkio]

It's your own key column's name in Table2