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.
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!!