I have a form where the user is either selecting an existing name or
adding a new name. If existing, I'm pulling in the email address for
that name, if new, they can enter a new corresponding email address.I'm
using this formula in as suggested value...