Why My Lookup Function is not working? Having Two Tables -
“Assigned Operators” having Emp Id, Short Name, Status “Test Data” having Emp Id, Short Name, Status.
Assigned Operators is my transaction table. If i add one row in “Assigned Operators”, the status should be reflected in “Test Data”. I used this formula =ANY(SELECT(Assigned Operators [Status], [Short Name] =[_THISROW].[Short Name] ))
And tried with LOOKUP formula. =LOOKUP([_THISROW].[Short Name], “Assigned Operators”, “Short Name”, “Status”)
But, if i have virtual column for “Status” in Test Data, its working.
Please help me out with this.