Hi folks, I am trying to create a training menu planner. On my first sheet I have the type of day Training/ Rest and then for each day I have five meal options and each has to be made up of 6 variables. On sheet 2 I have I have twelve lists that give the options for each of the variables (training or rest). I was hoping that by selecting training or rest from apicklist in column A I could write formulas that meant that each of the variable columns selected from the correct list however this is where I'm stumped. Any ideas. Template shared.