How to Create a Random Generator

Hello,

Can anyone help me? I would like to create a random calculation through vba that will pick a persons name. I would like it to first choose a state, then choose a gender(male of female), then based on the state and gender it will select a name from a group specific to the state and gender. i have try this using the rand and rank functions but i'm certain that there is an easier way.

I attached a file with what i have attempted so far but failed. Attachment 209596ed

If any of what i explained does not make any sense i apologize and would be more than happy to clarify.

Thank you,