Hello,
I have a simple table: header row is clients, 1st column are employees. Each
employee is assigned a primary client and 1 or more secondary clients. Where
the employee meets the primary client, a "P" is put in the cell. "S's" are
put in cells where employees meet their 2ndary client(s). These P's and S's
may vary daily.
I want to use a function to build two tables out of this data: one with all
the employees names and their corresponding primary and secondary clients,
and one with the clients name and their "primary" corresponding employee.
This would change when the P's and S's would move in the main table.
I tried the LOOKUP function and it worked for most employees but not all.
The order in which the P's and S's are is not what's affecting this.
Should I use a different function altogether? Will I have problem having
more than one S in several rows? (If so, I can rename S1, S2, etc...)
Thank you,
Caroline