Home > Mobile >  Random cell with index & match with extra criteria in another column
Random cell with index & match with extra criteria in another column

Time:03-18

I got three columns: Level, Calculation and Answer. To choose a random calculation, I use the formula: =INDEX(B2:B16, RANDBETWEEN(1, COUNTA(B2:B16)))

To get the related answer, I use the formula: =INDEX($C$2:$C$16,MATCH(F2,$B$2:$B$16,0))

Now I want to choose a random calculation based on the level in the first column. So instead of choosing a random calculation from the 15 calculations in column B, I want it to choose a random calculation from column B where column A for example is '2'.

Is this possible and if yes, how?

enter image description here

  • Related