Excel function help

[Deleted]

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!

[#2 · Accepted solution]

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

[#3]

Thank you very much for your help! Works perfectly!

-Jeremy