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)
REQUIREMENTS
If value of IF (1st formula) is 1 and vlook vlaue is also 1 then output shd b true or else false

• Re: Iserror err

The first formula isn't complete, but you could use the AND function.

• Re: Iserror err

hi...
thanks for the help ,the same way i wanted the formula to search the blank if the both the formulas output is blank "" then true or else flase
i wanted the formula to be included in the
=IF(and(ISNUMBER(SEARCH("xxx",B1)),VLOOKUP (A1,TABLE AARAY, 12,0)=1),1,"")

• Re: Iserror err

[cp]*[/cp]

Read them all, but especially rule 4b

Ger

_______________________________________________
There are 10 types of people in the world. Those that understand Binary and those that dont.

Why are Halloween and Christmas the same? Because Oct 31 = Dec 25...

_______________________________________________

Participate now!

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