I have a form with a calculated value control, and want to use the lookup function to retreive the value from another SharePoint list. The value to compare would be the current user, and a people picker value on the second list. The results are returning #Value!
Calculated Value Control:
The control with the current user has the Item Property set to Name
Lookup List:
Returned Value: