What should have been:
=lookup(“scmProjects”,”Project”,(brad),”Legal Entity”)
ended up as:
=parseLookup(lookup(“scmProjects”,”Project”,parseLookup(brad),”Legal Entity”))
Parameters are: list name, lookup key, named control containing key ( in this example “brad” ), returned value.
So where was this documented? Only with the assistance of an experienced developer was this resolved.