SOLVED

Problème INDEX et EQUIV

%3CLINGO-SUB%20id%3D%22lingo-sub-2925648%22%20slang%3D%22fr-FR%22%3EINDEX%20and%20EQUIV%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2925648%22%20slang%3D%22fr-FR%22%3E%3CP%3EGood%20morning%20everyone%2C%3C%2FP%3E%3CP%3EAllow%20me%20to%20write%20to%20you%20so%20that%20you%20can%20help%20me%20to%20solve%20this%20problem.%3C%2FP%3E%3CP%3EIndeed%2C%20I%20combined%20the%20two%20formulas%20INDEX%20and%20EQUIV%2C%20and%20it%20worked%20well%20on%20cells%20and%20not%20on%20others.%20The%20formula%20being%20correct%2C%20I%20may%20not%20understand%20the%20exact%20concern%2C%20since%20it%20applies%20correctly%20on%20cells%20and%20not%20on%20others.%3C%2FP%3E%3CP%3EI%20am%20attaching%20the%20Excel%20file%20to%20you%2C%20and%20thank%20you%20in%20advance%20for%20your%20help%20and%20involvement.%3C%2FP%3E%3CP%3EVery%20cordially%2C%3C%2FP%3E%3CP%3EMiryam%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CEM%3EHello%20everyone%2C%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CEM%3EI%20would%20like%20to%20write%20to%20you%20so%20that%20you%20can%20help%20me%20solve%20this%20problem.%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CEM%3EIndeed%2C%20I%20had%20to%20combined%20the%20two%20formulas%20INDEX%20and%20EQUIV%2C%20and%20it%20worked%20well%20on%20some%20cells%20and%20not%20on%20others.%26nbsp%3B%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CEM%3EThe%20formula%20being%20correct%2C%20but%20I%20do%20not%20understand%20the%20exact%20problem%2C%20since%20it%20applies%20correctly%20on%20some%20cells%20and%20not%20on%20others.%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CEM%3EI%20am%20attaching%20the%20Excel%20file%2C%20and%20thank%20you%20in%20advance%20for%20your%20help%20and%20involvement.%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CEM%3EBest%20regards%2C%3C%2FEM%3E%3C%2FP%3E%3CP%3EMiryam%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2925648%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2925772%22%20slang%3D%22en-US%22%3ERe%3A%20Probl%C3%A8me%20INDEX%20et%20EQUIV%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2925772%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1206645%22%20target%3D%22_blank%22%3E%40Miiryam%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20suggest%20you%20a%20different%20approach%3C%2FP%3E%3CP%3E%3DINDEX(Feuil2!%24D%243%3A%24D%2425%2CMATCH(%3CFONT%20color%3D%22%23FF0000%22%3E(%24C%242%2BA4)%3C%2FFONT%3E%3BFeuil2!%24A%243%3A%24A%2425%3B0)%2C1))%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%22JulianoPetrukio_0-1636018399442.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F324170i1F8FDB360C4BCEF4%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22JulianoPetrukio_0-1636018399442.png%22%20alt%3D%22JulianoPetrukio_0-1636018399442.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFind%20attachment%20with%20the%20formula%20applied%20on%20column%20C%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Good morning everyone,

Allow me to write to you so that you can help me to solve this problem.

Indeed, I combined the two formulas INDEX and EQUIV, and it worked well on cells and not on others. The formula being correct, I may not understand the exact concern, since it applies correctly on cells and not on others.

I am attaching the Excel file to you, and thank you in advance for your help and involvement.

Very cordially,

Miryam

 

Bonjour à toutes et à tous,

Je me permets de vous écrire afin que vous puissiez m'aider pour la résolution de ce problème.

En effet, j'ai du combinée les deux formules INDEX et EQUIV, et ça marchaient bien sur des cellules et pas sur d'autres. 

La formule étant correcte, mai je ne comprend pas le soucis exacte, puisqu'il s'applique correctement sur des cellules et pas sur d'autres.

Je vous mets en pièces jointes le fichier Excel, et je vous remercie d'avance pour votre aide et votre implication.

Bien cordialement,

Miryam

3 Replies
best response confirmed by Miiryam (New Contributor)
Solution

@Miiryam 

I suggest you a different approach

=INDEX(Feuil2!$D$3:$D$25,MATCH(($C$2+A4),Feuil2!$A$3:$A$25;0),1))

 

JulianoPetrukio_0-1636018399442.png

 

 

Find attachment with the formula applied on column C

Hello,

@Juliano-Petrukio

It’s magical, thank you very much for your help and your solution.
It works really well, I really appreciate that.
Thanks again !
Any time.
Its good to hear that I could help you and thanks for your feedbacks as well.