Highlight cell not in lookup

[lapta301]

Hi

I have a master list of 3 digit codes in J2:J30 with data values in column H.
I would like a CF formula in column H to show which cell values are not in J2:J30

As an example one of the codes is HVE

As ever any help is appreciated.

 

[Fluff]

How about
=ISERROR(MATCH(H2,J$2:J$30,0))

 

[lapta301]

Thank you Fluff it works a treat

 

[Fluff]

Glad to help & thanks for the feedback