I have two tables. One table contains customer name and contact info. I have a second table that contains customer name, invoice numbers, job discriptions, date of service. I would like to take the second table and add the contact information from table 1 to each record (row) in the second table using the name as the common piece of data.
Anyhelp?
MacBook Pro 13″, macOS 10.14
The XLOOKUP function will do what you describe.
The formula in C2, filled right and down:
=XLOOKUP($A2,Table 1::$A,Table 1::B,"NF")
Use ; instead of , in the formula if your regions uses , as the decimal separator.
More in XLOOKUP here.
(This is also accessible via Help > Formulas and Functions Help in your menu.)
SG
The XLOOKUP function will do what you describe.
The formula in C2, filled right and down:
=XLOOKUP($A2,Table 1::$A,Table 1::B,"NF")
Use ; instead of , in the formula if your regions uses , as the decimal separator.
More in XLOOKUP here.
(This is also accessible via Help > Formulas and Functions Help in your menu.)
SG
neverworks wrote:
iWhere do i put that formula?
The screenshot shows where the formula is. Also, I wrote "The formula in C2 ...."
If you start by reproducing what I did you should get the idea.
If you are new to Numbers be sure to have a look at Help > Numbers Help in the menu. Also have a look at the templates at File > New in your menu and at the link I provided about the XLOOKUP formula.
SG
im not understanding this. Where do i put that formula? In your example you show 2 tables. Im expecting i would end up needing a third table and i am taking data from 2 tables.
NW,
This may help you to navigate Numbers Window Features, and understand SG's post.
Jerry
extract data from on table based on the values in a column in a different table
