Compare two lists and give exact match

[mccrimmon]

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

[NBVC]

Try:

=if(isnumber(match(E3,$D$3:$D$300,0)),E3,"item is missing")

copied down