Compare range data to another column data

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.

Please Login or Register  to view this content.

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.

Originally Posted by canapone

Hi,

an attempt. I'd need a sample file to adjust formula

Formula:

Please Login or Register  to view this content.

Cheers

Please check attachment and yes i also tried

Please Login or Register  to view this content.

And

Please Login or Register  to view this content.

Originally Posted by canapone

Hi again,

if you need true or false as outputs

Formula:

Please Login or Register  to view this content.

Hope it helps

Yes this is perfect. Thanks