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.
I tried to put range width wildcard but its not giving me correct result.Little help here.![]()
=IF(A1="","",IF(ISNUMBER(SEARCH("*Pizza*",A1)),"True","False"))
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.
Bookmarks