View original (French)

Hello everyone! Formula search!

Solved
TATA_2000 Posted messages 29 Status Member -  
PHILOU10120 Posted messages 6463 Registration date   Status Contributor 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 answers

  1.
    cousinhub29 Posted messages 1114 Registration date   Status Member Last intervention   382
     

    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
  2. TATA_2000 Posted messages 29 Status Member
     

    Thank you so much, Cousin!!!

    Have a great day

    Cltd

    0
  3. PHILOU10120 Posted messages 6463 Registration date   Status Contributor Last intervention   835
     

    Hello

    another idea

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

    0