Replicate data in one cell to another cell dependent on description

Hello,

I'm looking for a formula that will look for identical data from one column, check to see if there is data present in a another column and if there is -
copy that data into all the corresponding cells into a separate column.

In my attached spreadsheet Column F has duplicate values (shown in red). I would like Excel to look to see if there is anything in column L (in my example: "clear in July") and if there is, copy that data into all the corresponding cells in Column N

Hope this gives enough information.

Thank you
S

ARRAY Formula

Please Login or Register  to view this content.

ARRAY Formula should be confirmed with Ctrl+Shift+Enter keys, Not With only Enter Key.

Thank you, it was a little tricky with the array but I think I have it.
Thanks so much

This is great. Thank you very much. I appreciate your help