To start with, here is what I am trying to do: On a form, I want to lookup (from another list) and based on the currentuser, return another column, from that list.

Based on the currentuser, go out to an Approver list, and find that person's approver.

The Approver list has Employee (People), TravelApprover (People).

I'm trying to use a calculated Value with the following formula:

lookup('Approver','Employee','Employee', 'TravelApprover')

The second Employee in the function is a Named Control.

Nothing is being returned.  I must be missing something, I would think this would be pretty easy.