Link specific text in one cell to another so =Named Manager list comes up data validation

Hi all,

I have set up a workbook with several different sheets. I currently have it set up across the sheets that you can only pick the time once for a day from the data validation list so no duplicates are present over the 6 sheets.

I am trying to set it up now that if a specific text is found in a cell range, say A1:A7 (Say Wednesday in ) that in the cell next to it, it brings up the data validation for Wednesday's time no matter where it is located in the list.

Therefore:-

Look up in A2 the day and then populate the data validation (time of meal) from that day in cell next to it.

So Wednesday appears in any location of A2:A8 it returns the data validation (time) for that day in column C's location not having to manually change C2's data validation to look at Wednesdays time !

So like dynamic or vlookup ? But maybe a different way is better / possible.

Hope this makes sense. I have attached a file working and then what I would like to do.

Thanks,

Matthew.

Thank you for your fast response FDibbins.

Is there anywhere you can direct me to or know how to do this in VBA ?

Thanks,

Matthew.