Hi Experts-
I'm creating a Shirt Order Form spreadsheet with dropdowns using Data Validation. I have 2 different types of shirts to choose from in F6, i would like the choices in H6 (shirt color) to change based the type of shirt chosen in F6. I'm attempting to do this using an IF statement in the Data Validation Source. I either get an error message or the drop down works for one and not the other.
I've found several posts on this topic and have come across several suggested formulas, but none seem to be working. I'm sure its a minor thing i'm overlooking, so i've attached the sheet for review.
I have data lists named in sheet2.
Thanks!
Bookmarks