hi there 1 sheet. In cell A2 I want to enter a day of the week and have other cells use that as a reference to return data to its cell. E.,g
 
   a                   b                   c                    d
Day                Color 1           Color 2             Color 3
Monday           Red                 Blue              Yellow
The day Tuesday has a differnent set of colors for 1, 2 and 3.