Formulas between tables

[Bart]

I have 2 tables in base:
- in table 1 i have column with name of the brand: ex: Royal Shop
- in table 2 i have row where i have 2 columns brand (Royal Shop), and e-mail adress (royalshop@email.com)

i would like to write formula in table 1 where i would like to copy e-mail adress which is connected with brand from table 2

How to do it?

[TheTimeSavingCo]

You can't use a formula like that I'm afraid.  You should link them up and then use lookup fields to do that I think