Forum Discussion
IFS and RANDBETWEEN HELP NEEDED
Purpose: Create a dummy dataset with specific conditions Data so far: Column B: Pick a random value between K2 and K3 and store it in this respective cell [Do this for every cell in Column B] ...
Your own formula if adjust a bit shall work
=IF(B2=$K$6,
INDEX($L$6:$L$8,RANDBETWEEN(1,COUNTA($L$6:$L$8)),1),
INDEX($M$6:$M$8,RANDBETWEEN(1,COUNTA($M$6:$M$8)),1)
)