Forum Discussion
Excel function help
Hi guys,
I'm trying to get the IF function to work with searching for partial text match
For example, If the "B" column contains "2010", return with a value of 2010, but if it contains "2009", return with a value of 2009.
Another would be if the "C" column contains the text "SG" OR "SPR" return with Local, otherwise return with Overseas.
Hope I'm not being too confusing.
Thanks for any help you guys can give!
Hi Yuen,
Please use the following two formulas and find them in the attached file:
=IF(ISNUMBER(SEARCH("2009",B1)),2009,IF(ISNUMBER(SEARCH("2010",B1)),2010,""))=IF(SUMPRODUCT(--ISNUMBER(SEARCH({"SG","OR","SPR"},C1))),"Local","Overseas")Hope that helps
2 Replies
Hi Yuen,
Please use the following two formulas and find them in the attached file:
=IF(ISNUMBER(SEARCH("2009",B1)),2009,IF(ISNUMBER(SEARCH("2010",B1)),2010,""))=IF(SUMPRODUCT(--ISNUMBER(SEARCH({"SG","OR","SPR"},C1))),"Local","Overseas")Hope that helps