tieing a set random item to other random name

[wolf735]

hello im creating a charter sheet for a game i play. im trying to get a randomly chosen name to appear based on gender of character. the two formals work by themsself but im having trouble getting the names to correspond to gender.

gender is =INDEX($E$5:$E$6,RANDBETWEEN(1,2)) e5 male
e6 female

for the name =IF(K10=1,INDEX('master names'!$B$2:$B$1355,RANDBETWEEN(1,1354)),INDEX('master names'!$C$2:$C$4383,RANDBETWEEN(1,4382)))

problem is in the logic test, playing around using 0 and 1 it works. if i say k10=male and k10 is male im getting female names.


thank you for help.

 

[MisterBate5]

If you formula in the cell choosing the name, does the following work as repalcement for the start of the formula?

=IF($K$10="male",INDEX(...

 

[wolf735]

thank you for help.