Data Validation List based on formula result

I know how to create a dynamic named range, and how to use data validation to create drop-down lists dependant on another drop-down list choice.

What I'm currently having issues with, is creating a drop-down list based on the result of a formula.

So in the internet examples of Fruit / Veg - my formula in the first cell creates the Fruit or Veg result, and based on that the second cell pulls out the drop down for either Fruit, or for Veg.

The drop down lists work if I type them in as =Veg / =Fruit, but if I try to use the first cell as an Indirect reference (ie. =indirect(A1), it just tells me the list evaluates to an error.

Is there a way to do this?

Thanks as always

Normal dependant drop-downs work as:

1st Box:
Fruit
Veg

2nd Box:
Either shows 'Fruit' list or 'Veg' list, depending on option chosen in First Box.



What I want, is the 1st box will be the result of a formula (ie. =IF(A1="F","Fruit","Veg"), not as a drop-down list.

The 2nd box is to be the dependant drop-down list as normal.

Yes, that's the idea.

I was hoping that the list could be based on the actual cell contents in A1 though, rather than hard-coded into the formula, as I'll have 15 options in total - not just 2 for fruit and veg!

My 15 ranges are all named exactly as the formula results would be - so if the formula returns 'Fruit', then the named range is also called 'Fruit'.