Return data from fields in same row after lookup

HI guys and girls

Can anyone pls tell me how, if I select a field with a lookup field (ie: Full Name) how I then get the system to populate 2 other fields I have Email and Phone with the email and phone from the table teh lookup was aimed at.

Are you looking for something like this - (https://help.coda.io/formulas/using-lookups)

Formulas and lookup columns

Since lookup columns pull all of the details about a row, you can actually use formulas with them by typing the column name, a dot (or period), and the value want to pull from the other table.

In the example above, we’re saying to show the email address of the Contact.

And, to save you time, you don’t even have to type a formula. When you create a new column, you’ll see the option to create new columns based on what you already have in the table:

That’ll do the trick!