How to use a statement to locate similar data in another table and output value of the same row

[Sheikh_Aqil]

Hi, I just started using Appsheet so I'm not used to the expression and formula part. Right now I'm making an app where the student can request merit marks and teachers can accept their request.

The statement is a list of type of activities that determines how much merit that they would receive.

The merit table holds a list containing statements (matching in the request table) that would determine how much merit they would get for the statement task.
I'm trying to get the student to choose the statement from the enum column and then it will ouput the merit they would get from the other merit table.

ANY(
SELECT(
Merit Data[Current Merit],
([Statement] = [_THISROW].[Statement])
)
)
this is the line of code I tried to use, but it doesn't update the merit mark after their request is updated.
After that i also want to add the current merit to another table (when the status column is changed to "accepted" ) to sum the merit in the request with the merit in the other table.

I tried to refer to examples but it doesn't seem to work, is there something wrong with the type of column i used or is there a settings that allow updating data immediately that I'm still haven't found.
I've been stuck with this for 3 days so I appreciate anyone who can help me and thank you for your precious time.