View original (French)

Hello everyone! Formula search!

Solved
TATA_2000 -  

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

    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
    1. TATA_2000 Author

      Thank you so much, Cousin!!!

      Have a great day

      Cltd

      0
      1. PHILOU10120 Contributor

        Hello

        another idea

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

        0