Forum Discussion
Solved
Je recherche une formule ayant des paramètres verticaux et horizontaux
[ Spoiler ]
=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.
=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.
- Thanks you!!! You resolve my problem!!
