Jul 22 2021 12:26 PM
Hello,
I hope you are all well. I have a list of about 2000 MDs that I'm trying to get excel to search and return the Sales person that is assigned to them. It's one workbook, one sheet with the list of 1928 MDs, one sheet with 450 outstanding order entries with 183 different MDs.
In my mind, I would like to insert a formula in the Sales Rep cell that will search the MD list and find the Sales Rep that is assigned to them. The cell then would show the Sales Rep. I.e. Dr. Miller is assigned to Julie, so all orders for Dr. Miller will show Julie as the rep.
Jul 22 2021 01:16 PM
You need categorization according to RACI
The RACI matrix is also called RAM, which stands for “Responsibility Assignment Matrix”.
You can make it to order, or purchase it in different sites like this one.
Or there is someone who already has some preliminary work in this direction and can / would like to make it available to you.
Here is an example Excel file with RACI matrix
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.
Jul 22 2021 06:35 PM