How to reference a Contact in a table formula?


I have a table that contains Contacts values and I want to add another column with a formula that establishes a value depending on the Contact Value, like this

Is there a way to reference the Contact value from the other column?

If matching by the display name doesn't work, one solution that comes to mind (and that I have used) is to have a separate table called eg. Contacts with the following columns:

  1. Contact: This is the contact itself
  2. Contact Identifier String: eg. "Diego Boet"

This way, your formula could read something like: IF(ListadoGastos[Pagador]=FINDROW(Contacts, "Contacts[Identifier] = %", "Diego Boet")[Contact], "OK", "NO")