IFS with Ref table

[Tech_Office_UNI]

Dear All,
I have one table name TASKS with 4 approval column and 4 approved level, Im creating virtual column to fill in who is current task owner.
My logic as below
https://www.evernote.com/l/ArFCxgOcBU1Cj5QMQE2mnBjValFc7MzlUi0
This is 4 ref tables
https://www.evernote.com/l/ArHhLo9VGy5KxZNDq024CXAudovaRKly9Vk
I need to get the name of current task owner into virtual column for email and approval purpose.
Please help to check

IFS(
AND( ([L1_Approved]= "No”), ([L2_Approved]= "No”) , ([L3_Approved]= “No”) , ([L4_Approved]=”No”) ), [L1_Approval].[Name],
AND( ([L1_Approved]= "Yes”), ([L2_Approved]= "No”) , ([L3_Approved]= “No”) , ([L4_Approved]=”No”) ), [L2_Approval].[Name],
AND( ([L1_Approved]= "Yes”), ([L2_Approved]= "Yes”) , ([L3_Approved]= “No”) , ([L4_Approved]=”No”) ), [L3_Approval].[Name],
AND( ([L1_Approved]= "Yes”), ([L2_Approved]= "Yes”) , ([L3_Approved]= “Yes”) , ([L4_Approved]=”No”) ), [L4_Approval].[Name]
)