I'm trying to create a Risk Assessment sheet in Excel.
I have one drop-down with days at the moment and I want another cell to be populated depending on what day is selected.
I have managed to get this working for one day but not all days.
How can I expand this formula to show the following:
F16 = Monday, G16 = Apple
F16 = Tuesday, G16 = Orange
F16 = Wednesday, G16 = Banana
F16 = Thursday, G16 = Pear