I am using the COUNTIF function as follows.

=COUNTIF(Data!AN2:AN533,LOV!A2)

It works for the most part, however, the fields I am looking up
(Data!AN2:AN533) may have more than one value in it.

That is, if LOV!A2 is "Car", Data!AN2, may have "Car, Train,..." or "Train,
Car...).

Is there anyway to use Countif and a wild card value?

Thanks. Happy Holidays.