I'm trying to create a drop-down menu that is dependent on a previous cell in a row.

The data coming in from a DB is M or F. Male or female. Then from what is displayed there I want the next column to do a dropdown of only the categories that each gender is eligible for.

I'd rather do this via custom formula of data validation over a script but I've gotten to the end of the internet and can't quite get this solved.

Here is my sample data link: https://docs.google.com/spreadsheets/d/1OL4MTFELjnluo9o_dIBAMvDzsYarx7IKATodDqo2tU8/edit?usp=sharing

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.