2000 MDs and 3 Sales People - How Do I Search

%3CLINGO-SUB%20id%3D%22lingo-sub-2576919%22%20slang%3D%22en-US%22%3E2000%20MDs%20and%203%20Sales%20People%20-%20How%20Do%20I%20Search%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2576919%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20hope%20you%20are%20all%20well.%26nbsp%3B%20I%20have%20a%20list%20of%20about%202000%20MDs%20that%20I'm%20trying%20to%20get%20excel%20to%20search%20and%20return%26nbsp%3B%20the%20Sales%20person%20that%20is%20assigned%20to%20them.%26nbsp%3B%20It's%20one%20workbook%2C%20one%20sheet%20with%20the%20list%20of%201928%20MDs%2C%20one%20sheet%20with%20450%20outstanding%20order%20entries%20with%20183%20different%20MDs.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20my%20mind%2C%20I%20would%20like%20to%20insert%20a%20formula%20in%20the%20Sales%20Rep%20cell%20that%20will%20search%20the%20MD%20list%20and%20find%20the%20Sales%20Rep%20that%20is%20assigned%20to%20them.%26nbsp%3B%20The%20cell%20then%20would%20show%20the%20Sales%20Rep.%26nbsp%3B%20I.e.%20Dr.%20Miller%20is%20assigned%20to%20Julie%2C%20so%20all%20orders%20for%20Dr.%20Miller%20will%20show%20Julie%20as%20the%20rep.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2576919%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2577120%22%20slang%3D%22de-DE%22%3ESubject%3A%202000%20MDs%20and%203%20Sales%20People%20-%20How%20Do%20I%20Search%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2577120%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1110427%22%20target%3D%22_blank%22%3E%40USMC1114%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EYou%20need%20categorization%20according%20to%20RACI%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EThe%20RACI%20matrix%20is%20also%20called%20RAM%2C%20which%20stands%20for%20%22Responsibility%20Assignment%20Matrix%22.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EYou%20can%20make%20it%20to%20order%2C%20or%20purchase%20it%20in%20different%20sites%20like%20this%20one.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EOr%20there%20is%20someone%20who%20already%20has%20some%20preliminary%20work%20in%20this%20direction%20and%20can%20%2F%20would%20like%20to%20make%20it%20available%20to%20you.%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EHere%20is%20an%20example%20%3CA%20href%3D%22https%3A%2F%2Fvorla.ch%2Fraci-matrix%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EExcel%20file%20with%20RACI%20matrix%3C%2FA%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20any%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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.

2 Replies

@USMC1114 

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.

@USMC1114



index+match would be your go to formula. let us know if you need help. It would also help to create similar tables to your spreadsheet with dummy info and if you can share it that would speed things up.

cheers