IFS and RANDBETWEEN HELP NEEDED

[CrispyBacon95]

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]

Problem - How to:

Create an IF statement in Column C that does the following:

IF the value for the MATCHING ROW in Column B is K2:Pick a random value between L6 to L8 and store it in this cell

ELSE:
Pick a random value between M6 to M8 and store it in this cell

[#2]

@CrispyBacon95 

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)
)