I have a data validation in cell B4. I need cell B21 to auto populate with a drop down list based on the value selected in the B4 drop down.
For Example: If BREAKFAST FOOD is selected in cell B4, I need to the list in cells F37:F40 to appear in cell B21 as a drop down list.
I know how to do this with a nested if statement for up to 7 lists but I need to do it for 17 lists.
Got any ideas? Your help is greatly appreciated.