IFS and RANDBETWEEN HELP NEEDED

Occasional Visitor

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

 

1 Reply

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