Matching one cell value but column has same multiple entries in one column

Hi All

I have had a chance to check with your replies and can say that this is working so will need to close this.

Thank you again for your kind help.

Have a great day.

vba1234