I'm trying to write a formula that will prompt review based on certain criteria in a list. The only "true" return values I'm getting are on the argument with a greater than numberic value. Is there another/better way when 2 of the arguments are text values?
I'll try to get a sample file uploaded. Rules!A;A and Rules!B:B is referencing a range on another worksheet, same workbook. So if Q2 equals any value in the range in Column B on Rules tab, value should return "".