Forum Discussion
Solved
Je recherche une formule ayant des paramètres verticaux et horizontaux
Spoiler
Je recherche une formule pour lesquels il y a plusieurs paramètres, mais certains verticaux et d'autres horizontaux. Ça devient compliqué de faire des si imbriqués car la base de recherche est assez imposante. Voir exemple simplifié ci-joint (désolée je n'arrive pas à le joindre en excel). Merci
=INDEX($C$17:$I$23,MATCH(B5,$B$17:$B$23,0),MATCH($C5&$D5,$C$15:$I$15&$C$16:$I$16,0))Sorry i didn't realise that there are texts in range C17:I23. This formula seems to work in my sheet. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
4 Replies
=SUMPRODUCT((B5=$B$18:$B$25)*(C5=$C$16:$J$16)*(D5=$C$17:$J$17)*$C$18:$J$25)Maybe this is what you are looking for.
OliverScheurich Thanks! Do you know how do the formula when the reference zone is "text" (not number)?
=INDEX($C$17:$I$23,MATCH(B5,$B$17:$B$23,0),MATCH($C5&$D5,$C$15:$I$15&$C$16:$I$16,0))Sorry i didn't realise that there are texts in range C17:I23. This formula seems to work in my sheet. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
