Return data from fields in same row after lookup

Are you looking for something like this - (

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: