Forum Discussion

Eqa33's avatar
Eqa33
Brass Contributor
Jan 03, 2022
Solved

Extend ISNUMBER Search

Hi,

 

I have a Table of data one of the columns automatically inserts an option depending on the results in an earlier column. what I'm wanting to do is is look at 2 columns of info and depending on the combination  of the 2 columns assign a answer to the 3rd column. 

 

My current formula is =IF(L5="","",IF(ISNUMBER(SEARCH("dr",L5)),"FRE","GST"))

 

I now want it to look at column F as well and if the country in F doesn't equal USA then it should insert "EXP" if it does equal USA then it needs to revert to the above formula.

 

Thanks for your help,

 

Eqa

Formulas and Functions

6 Replies

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Jan 03, 2022

    Eqa33 That could be:

    =IF(F5="USA","EXP",IF(L5="","",IF(ISNUMBER(SEARCH("dr",L5)),"FRE","GST")))

     

    • Eqa33's avatar
      Eqa33
      Brass Contributor
      Jan 04, 2022
      That's great. Thanks very much. I actually needed it to say, if it doesn't equal USA then EXP, which I have fixed, but now even a blank cell is registering as EXP. what do I need to do to get it to ignore blank cells?
      Thanks again.

Resources