The following map rule returns the incorrect results; however, the map rule does return the
expected results when each LOOKUP is run independently.
=IF(PRESENT(Name:.:AddressFile), LOOKUP(Record:input,Field1 Field:Record:input=”aa”),
LOOKUP(Record:input,Field1 Field:Record:input=”cc”))
Why does the rule return the INCORRECT results?

A.
Both LOOKUPs reference the same series object.

B.
Two LOOKUPs are not allowed in a single map rule.

C.
IF(PRESENT) was used instead of WHEN(PRESENT).

D.
The syntax of the object name Name:.:AddressFile is incorrect.

Explanation: