I have two columns of data that are imported on a daily basis.

They are unique references that come from two different source systems and are populated in Columns D and Columns E.

In column F, I want to have a formula that says that if the unique reference in Cell E3 for example is populated anywhere in Column D from D3 to D300 then populate a match, if its not then state that its missing.

Can anyone help?

Thanks in advance