Looking for text in modules
Hi, I need some orientation on this:
I need to look for a text in the column "P2 product Brand" (first photo) in another module (second photo) and if it is there, I need to return TRUE otherwise False this formula should populate the last column of the first photo. Both columns are formatted as lis, and they are populated using the same list.
I've tried using the lookup function, but it returns an error mismatching common dimension, I also tried "finditem" function but it returns a list and I need a boolean. Any Idea on how should I approach my formula? Thanks