Hi Pete,

Thanks for the assist. I'm getting better, but not there yet.

K3 or AC3 can match. K3 is the open date and AC3 is the closed date. They
may or may not open/close in the same month. That is why I want it to search
for the month match in AE1.

Column X may be empty if no remarks are required.

"Pete" wrote:

Hi Roy,

trouble with IF again ?

Are you saying that AC3 (only) has to match the month and year in AE1,
or can EITHER K3 OR AC3 match with AE1? Can you guarantee that column X
will contain some text (i.e. not empty)?

Pete