Hi I am having a bit of a problem trying to figure out the exact formula and syntax I need.
I have two sheets, Sheet 1 has all the information about various products and sheet 2 has the data for my drop down boxes. On sheet 1 I use a drop down box in column F to pick from 4 standard sizes. What I need is:
If F2 equals Size 1 from the drop down list in column F then I want column E to give me another drop down list based on the value of F2. I'm not sure how to formulate this.
So if F2=Size1 then E2=Size1DropDownList that gives me the options from that list.
Bookmarks