Produit d'une RECHERCHEV

%3CLINGO-SUB%20id%3D%22lingo-sub-3235463%22%20slang%3D%22fr-FR%22%3EProduct%20of%20a%20VLOOKUP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3235463%22%20slang%3D%22fr-FR%22%3E%3CP%3EHello%2C%20I%20can't%20find%20the%20right%20formula%20structure%20to%20avoid%20doing%20VLOOKUP()%20*%20VLOOKUP()%20*%20VLOOKUP()%20while%20technically%20my%20lookup%20refers%20to%20the%20same%20line.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETable%201%20(destination)%3C%2FP%3E%3CTABLE%20border%3D%221%22%20width%3D%2244.44407185461659%25%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2233.333333333333336%25%22%3EEmployee%3C%2FTD%3E%3CTD%20width%3D%2233.333333333333336%25%22%3E(%24)%20Project%20Manager%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2233.333333333333336%25%22%3EName1%3C%2FTD%3E%3CTD%20width%3D%2233.333333333333336%25%22%3E%3CP%3E**Mystery%20formula**%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EName5%3C%2FTD%3E%3CTD%3E%3CP%3E**Mystery%20formula**%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3ETable%202%20(reference)%3C%2FP%3E%3CTABLE%20border%3D%221%22%20width%3D%22100%25%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2225%25%22%3EEmployee%3C%2FTD%3E%3CTD%20width%3D%2225%25%22%3Etx%20imputab.%3C%2FTD%3E%3CTD%20width%3D%2225%25%22%3Enbr%20hours%3C%2FTD%3E%3CTD%20width%3D%2212.5%25%22%3ERate%3C%2FTD%3E%3CTD%20width%3D%2212.5%25%22%3EProject%20Manager%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2225%25%22%3EName1%3C%2FTD%3E%3CTD%20width%3D%2225%25%22%3E0.95%3C%2FTD%3E%3CTD%20width%3D%2225%25%22%3E40%3C%2FTD%3E%3CTD%20width%3D%2212.5%25%22%3E%2485.00%3C%2FTD%3E%3CTD%20width%3D%2212.5%25%22%3E50%25%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2225%25%22%3EName2%3C%2FTD%3E%3CTD%20width%3D%2225%25%22%3E0.5%3C%2FTD%3E%3CTD%20width%3D%2225%25%22%3E37.5%3C%2FTD%3E%3CTD%20width%3D%2212.5%25%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2212.5%25%22%3E100%25%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E**Mystery%20formula**%20must%20give%20me%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3CEM%3Etx%20imputab.%20*%20nbr%20hours%20*%20Project%3C%2FEM%3E%3C%2FSTRONG%3E%20manager%20for%20employee%20%3CSTRONG%3EName1%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3235463%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3237422%22%20slang%3D%22en-US%22%3ERe%3A%20Produit%20d'une%20RECHERCHEV%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3237422%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1320952%22%20target%3D%22_blank%22%3E%40CathPref%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20need%20to%20use%20the%20vlookup%20for%20every%20number%2C%20so%20the%20formula%20will%20be%20like%20this%3A%3C%2FP%3E%3CP%3E%3DVLOOKUP(A3%2C%24A%248%3A%24E%249%2C2%2CFALSE)*VLOOKUP(A3%2C%24A%248%3A%24E%249%2C3%2CFALSE)*VLOOKUP(A3%2C%24A%248%3A%24E%249%2C4%2CFALSE)*VLOOKUP(A3%2C%24A%248%3A%24E%249%2C5%2CFALSE)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22vlookup.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F352125i3FB3BE01AE077C0D%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22vlookup.png%22%20alt%3D%22vlookup.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3237641%22%20slang%3D%22fr-FR%22%3ERe%3A%20Product%20of%20a%20VLOOKUP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3237641%22%20slang%3D%22fr-FR%22%3E%3CP%3EThank%20you%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F87534%22%20target%3D%22_blank%22%3E%40Jihad%20Al-Jarady%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20was%20looking%20for%20a%20way%20to%20avoid%20it.%20I%20thought%20there%20had%20to%20be%20a%20simpler%20formula.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3240299%22%20slang%3D%22en-US%22%3ERe%3A%20Produit%20d'une%20RECHERCHEV%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3240299%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1320952%22%20target%3D%22_blank%22%3E%40CathPref%3C%2FA%3E%26nbsp%3BPerhaps%20like%20in%20the%20attached%20file.%20It%20will%20translate%20to%20your%20own%20locale.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Riny_van_Eekelen_0-1646214813112.png%22%20style%3D%22width%3A%20503px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F352327iC14A68F0FD866AB5%2Fimage-dimensions%2F503x194%3Fv%3Dv2%22%20width%3D%22503%22%20height%3D%22194%22%20role%3D%22button%22%20title%3D%22Riny_van_Eekelen_0-1646214813112.png%22%20alt%3D%22Riny_van_Eekelen_0-1646214813112.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Bonjour, je n'arrive pas à trouver la bonne structure de formule afin d'éviter de faire RECHERCHEV() * RECHERCHEV() * RECHERCHEV() alors que techniquement mon lookup réfère à la même ligne. 

 

Tableau 1 (destination)

Employé($) Chargé de projet
Nom1

**Formule mystère**

Nom5

**Formule mystère**

Tableau 2 (référence)

Employétx imputab.nbr heuresTauxChargé de projet
Nom10.954085.00$50%
Nom20.537.5 100%

**Formule mystère** doit me donner

tx imputab. *  nbr heures * Chargé de projet pour l'employé Nom1

3 Replies

Hi @CathPref 

 

You need to use the vlookup for every number, so the formula will be like this:

=VLOOKUP(A3,$A$8:$E$9,2,FALSE)*VLOOKUP(A3,$A$8:$E$9,3,FALSE)*VLOOKUP(A3,$A$8:$E$9,4,FALSE)*VLOOKUP(A3,$A$8:$E$9,5,FALSE)

 

vlookup.png

 

Merci @Jihad Al-Jarady 

Je cherchais une façon de l'éviter. Je me disais qu'il devait bien y avoir une formule plus simple.

@CathPref Perhaps like in the attached file. It will translate to your own locale.

Riny_van_Eekelen_0-1646214813112.png