Iserror err

  • Hi team

    Was looking for an formula, actually an combination of two formulas

    1)if(iserror(search(B1,"XXXX", 1),"",1

    2)VLOOKUP (A1,TABLE AARAY, 12,0)


    If value of IF (1st formula) is 1 and vlook vlaue is also 1 then output shd b true or else false

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!