Forum Question: How Do I Merge Two Tables Using Lookup In Mac Numbers?

I would like to merge two separate tables of data using the lookup function in Mac Numbers. For example, Table 1 is a list of names, addresses, emails, and cell phone numbers. Table 2 is a list of names, addresses, and landline numbers.

I want to merge Table 2 into Table 1 so that the landline phone numbers will match up with the corresponding address in Table 1.
—–
Adam

Comments: One Response to “How Do I Merge Two Tables Using Lookup In Mac Numbers?”

    8/2/18 @ 12:41 pm

    I would use the LOOKUP function to get the phone number from table 2 and put it into a new column in table 1. The example at A Simple Numbers Lookup Example should get you there. The only problem could be if the addresses aren’t exact matches.

    Once you have that, then you can select the results in that new column. Edit, Copy. Then with the same cells selected, Edit, Paste Formula Results. The replaces all of your LOOKUP functions with the real values. Now you can dispose of table 2 and you are all set.

Leave a New Comment Related to "How Do I Merge Two Tables Using Lookup In Mac Numbers?"

:

:

:


0/500 (500 character limit -- please state your comment succinctly and do not try to get around this limit by posting two comments)