Hi All,
Happy belated new years greetings to you all.
I need your help on my query.
I have 2 spreadsheets. Spreadsheet 1 is the main register and Spreadsheet 2 is a schedule. Linking all required details from S1 to S2 is ok using VLOOKUP function except for the last part of the schedule.
The last part of the schedule has 2 columns which forms a list of names of employees and their title on the next column.
In the Register table there are 2 columns that I will look at. 1 is the firm name and 2 is the name of employees. How can I pull the details of all employees under a firm name and show it on the schedule.
My schedule list table looks something like this.
Name of Employees Title
John Doe Sales Manager
Mary Wick Sales Rep
Hope this is clear.
Regards,
Bluwara
Happy belated new years greetings to you all.
I need your help on my query.
I have 2 spreadsheets. Spreadsheet 1 is the main register and Spreadsheet 2 is a schedule. Linking all required details from S1 to S2 is ok using VLOOKUP function except for the last part of the schedule.
The last part of the schedule has 2 columns which forms a list of names of employees and their title on the next column.
In the Register table there are 2 columns that I will look at. 1 is the firm name and 2 is the name of employees. How can I pull the details of all employees under a firm name and show it on the schedule.
My schedule list table looks something like this.
Name of Employees Title
John Doe Sales Manager
Mary Wick Sales Rep
Hope this is clear.
Regards,
Bluwara
