I have two tables, one with email address (Column A) and a number of other columns, and one with email address (Table 1, Column A) and zip code. I wanted to move the zip code column to the first table linked by email address. The Numbers Lookup function makes that happen:
Lookup(A,Table 1::A, Table 1::Postal Code)
If text columns need to be merged, use the following formula:
=A1&” “&A2