Forum Discussion
Is there a similar way of structured references with additional rows & columns from single table?
I am trying to make a small employee tracker/database for a federal job. - I would like to have a single master table that has 3 columns and 50 rows of employee info: Column A: SECTION Column B...
You could do 1 master table if they are all based on the same data set (i.e. same set of employees) and then just have different reports on other tabs.
If you want different tabels then you could have a linking ID and then use LOOKUP function (i.e. XLOOKUP is latest and 'greatest') to pull in the other information into each of the other tables. I would recommend Format as a Table (button found on Home tab). Then for example the 'base' table above you could call Empoyees and let's say you add a column called ID then the other tables would call something like this to get the corresponding section for the ID in 'this' table from the Employee table:
=XLOOKUP( [ID], Employees[ID], Employees[Section], "n/a")
If you want different tabels then you could have a linking ID and then use LOOKUP function (i.e. XLOOKUP is latest and 'greatest') to pull in the other information into each of the other tables. I would recommend Format as a Table (button found on Home tab). Then for example the 'base' table above you could call Empoyees and let's say you add a column called ID then the other tables would call something like this to get the corresponding section for the ID in 'this' table from the Employee table:
=XLOOKUP( [ID], Employees[ID], Employees[Section], "n/a")