Compare range data to another column data

[mobeenraheem]

I have 121 values in C column which i need to compare A column 5k values.

I made simple IF formula where "Pizza" with wild card represent C column data.

=IF(A1="","",IF(ISNUMBER(SEARCH("*Pizza*",A1)),"True","False"))

I tried to put range width wildcard but its not giving me correct result.Little help here.

Also i tried one more thing i nested this formula for 121 values and off course excel giving me Error about more then 64 levels of nesting.

 

[oldbrewer]

are you looking for "pizza" anywhere in A1:A5000 ?

 

[mobeenraheem]

are you looking for "pizza" anywhere in A1:A5000 ?

Not only "Pizza" i wanna search C1:C121 range data into A1:A5000 If found then true else False
Also please note i wanna use wildcard "*Pizza*" for C column data.

 

[oldbrewer]

still not clear friend, show us the first 10 rows of cols A to C with the outcome you want

 

[mobeenraheem]

I also tried but its not working.

=IF(A1="","",IF(ISNUMBER(SEARCH({"*Pizza*"; "*American (Traditional)*"},A1)),"True","False"))

And

=IF(A1="","",IF(ISNUMBER(SEARCH("*"&$C$1:$C$121&"*",A1)),"True","False"))