donner résultat en fonction d'un département

%3CLINGO-SUB%20id%3D%22lingo-sub-1503634%22%20slang%3D%22fr-FR%22%3Egive%20results%20according%20to%20a%20department%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1503634%22%20slang%3D%22fr-FR%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3EI%20have%206%20salespeople%20who%20share%20all%20the%20departments%20of%20France%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20assign%20an%20area%20number%20based%20on%20the%20department%3C%2FP%3E%3CP%3EI%20would%20like%20a%20formula%20that%20searches%20in%20a%20column%20to%20give%20the%20result%201%20or%202%20or%203%20or%204%20or%205%20or%206.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EE.g%3A%26nbsp%3B%3C%2FP%3E%3CP%3Eif%20department%2001%20then%206%3C%2FP%3E%3CP%3Eif%20department%2002%20then%203%3C%2FP%3E%3CP%3Eif%20department%2003%20then%206%3C%2FP%3E%3CP%3Eif%20department%2004%20then%206%3C%2FP%3E%3CP%3E...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1503634%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Bonjour,

J'ai 6 commerciaux qui se partagent tous les départements de France

 

Je souhaite attribuer un numéro de secteur en fonction du département

Je voudrais une formule qui recherche dans une colonne pour donner le résultat 1 ou 2 ou 3 ou 4 ou 5 ou 6.

 

ex : 

si département 01 alors 6

si département 02 alors 3

si département 03 alors 6

si département 04 alors 6

...

1 Reply

@EstelleLURO Hello I used Google translate to understand your query and just to let you know your query is very simple but for that I will need your help.

 

Create a list of all deptartments with the required number and then use formula of Vlookup

 

this will be easy