Hi

In cell b4, b5 and b6I have 3 makes. In Kolum b12 up to B25 I have text in
which I want to check if one of these makes are mentioned.

Presently I have formula: =IF(COUNTIF(B12,B4),"Make X","No")

but that only allows to search for one make. Changing B4 into B4:B6 does not
work. How can I do this?

rgrdds

Robert