It will make a lot more sense if you see the file yourself, trust me. Please see attached.
In the Fruit tab, in Row 2 and 3 is what I want my data to look like for all other rows.
My problem is that the Data Validation in Column C doesn't seem to like an Indirect function that is referring to a named range that uses an Offset.
What I want:
Respectively, in Fruit C2, C3, my data validation refers to
However, Test_Apple/Test_Banana don't work for me because I will have over a dozen "Test_"'s. I need this to be more dynamic.
My attempted solutions that give me errors:
Respectively, in Fruit C4, C5, C6, my data validation refers to
Please help! I'm confuzzled.