Using list to check value of a cell

Pls check the files


Azumi

Thanks Azumi,

But doesn't work when i transfer it across as some of my product has more than 3 characters.

for example:

Product = CPP RNC 3820 search list would be looking for RNC
or
Product = SUN OSS-RC 13A search list would be looking for OSS-RC