Fotis, thank you, however the problem with this is that the companies in the two lists do differ in name slightly due to some of them having PLC at the end and some not. Therefore COUNTIF is not picking them up

I think a formula like Pete suggested could work possibly, however I don't really understand it haha!