Mar 9 2012, 12:53 PM
I am mid-way through my project and have hit a snag.
In the case of my coding, I insert a column named "eval" and would like to apply a business process based off another cell.
My eval column (column O) would evaluate column M and N for instances of certain text criteria and if a certain text criteria is in column M or N i would apply a value as an eval.
If M2 = "3B" and N2 = "*PG*" then the result for eval would be PG.
I use the wildcards because N2 may have several codes in no specific order.
Could anyone please help get me started on trying to achieve this?
Thanks in advance
Mar 9 2012, 12:57 PM
You can test for the presence of PG by using Find, wrapped with IsErr test and subject to your other criterion:
Mar 9 2012, 01:02 PM
as another alternative, and you can change the "no" to whatever you want to use if the criteria is not met
forgot to copy the right one...
Mar 9 2012, 01:07 PM
Wow, both of these answers work great. I sincerely appreciate the help from you all.
Take care and again, thanks!!!
Mar 21 2012, 10:53 PM
Glad to help!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here