I have a form that has 2 lookup lists that lookup the Site and Buildings, these are 2 separate lists.  I also have a third list that contains the approver for the building/site which i would like the approver name and email address to be pulled through from this list onto the form.

I have the lookup lists pulling the data through, but i'd like to have the approver name and email address populated on calculated values.

The formulas that I have used are:

lookup("Approvers","Building",parseLookup(Building),"Approver")

lookup("Approvers","Building",parseLookup(Building),"Email")

But this doesn't pull the data through that I'm expecting.  There are 2 sites, both sites could have building names/numbers that are the same, but with different approvers.