View original (French)

Hello everyone! Formula search!

Solved
TATA_2000 Posted messages 29 Status Membre -  
PHILOU10120 Posted messages 6463 Registration date   Status Contributeur Last intervention   -

Hello,

Hello everyone

Please! A formula to simultaneously find the numbers on the grid, for example:

Age: 18

Duration: 13

On the grid we have: 69 150

Thank you in advance

Best regards

https://www.cjoint.com/c/MDypFDrBk0c

3 réponses

Réponse 1 / 3
cousinhub29 Posted messages 1112 Registration date   Status Membre Last intervention   383
 

Hello,

Formula to insert in cell E33:

 =INDEX($C$7:$R$18,EQUIV(E30,$B$7:$B$18,0),EQUIV(E28,$C$5:$R$5,0))

Have a good end of the afternoon

2nd formula:

 =OFFSET($B$6,EQUIV(E30,$B$7:$B$18,0),EQUIV(E28,$C$5:$R$5,0))
1
Réponse 2 / 3
TATA_2000 Posted messages 29 Status Membre
 

Thank you so much, Cousin!!!

Have a great day

Cltd
0
Réponse 3 / 3
PHILOU10120 Posted messages 6463 Registration date   Status Contributeur Last intervention   833
 

Hello

another idea

=VLOOKUP($E$30,$B$7:$R$18,MATCH($E$28,$A$5:$R$5,0)-1)
0