Forum Discussion

Deleted's avatar
Deleted
Apr 11, 2018
Solved

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"...
Formulas & Functions
Need Help
  • Haytham Amairah's avatar
    Haytham Amairah
    Apr 11, 2018

    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

Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Apr 11, 2018

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

  • Deleted's avatar
    Deleted
    Apr 11, 2018
    Thank you very much for your help! Works perfectly!

    -Jeremy