Is there a way to set up Conditional Formatting (or something else) to put
text in a cell if a certain condition is met?
For example if Paul has January & Susan has April............
A1 is January then B1 automatically fills in Paul
A2 is April then B2 automatically fills in Susan
A3 is April then B3 automatically fills in Susan
A4 is April then B4 automatically fills in Susan
A5 is January then B5 automatically fills in Paul

I don't understand programming enough so I'm trying to find out if there is
something else I can do. Thanks in advance!