I'm very new to VBA so bear with me, but I'm trying to figure out how you would go about randomly choosing from a list based on multiple criteria in other columns. Essentially I want to "pick a name out of a hat" but only if that name meets the criteria. I only need it to return one item from the list, but I need it to be different every time.

Example.xlsx

In the attached file I have Names in Column A, Gender in Column B, and Available (Y/N) in Column C. I would like the macro to find a name from Column A that meets the criteria, for example, randomly return any of the names that are "Male" in Column B and have "Y" in Column C. Also, not sure if it's relevant or not, but names will be added to the list over time, so the range will change as well.

Hopefully that makes sense. Any and all help is appreciated. Thanks!