Need formula to locate and validate specific text from a string
Thanks a ton...this is working.
How many If statements can I use in one formula?
On Apr 7, 11:12*am, "ozgrid.com" wrote:
Hello,
Try;
=IF(OR(ISNUMBER(SEARCH("testing",A1)),ISNUMBER(SEA RCH("cold",A1)),ISNUMBER(*SEARCH("working",A1)))," Yes","No")"vinstream" wrote in message
...
Hi,
I have the following sample data in column A.
germany (testing)
Germany (cold)
Germany
Austria (Testing)
Austria (cold)
Austria (working)
Austria (other)
China
China (alternate)
In column B, I want it to show that if the cell to the left has any of
the words 'testing' or 'cold' or 'working' it should show "yes" in
Column B else show "no".
Is this possible?
Regards,
Vinstream- Hide quoted text -
- Show quoted text -
|