Iserror err

[libin baby]

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

 

[xlstime]

Hope you need this -

if(and(formula1=1 and formula2=1),TRUE,FALSE)

In above formula1 = if(iserror(search(B1,"XXXX", 1),"",1)
and
Formula2 = VLOOKUP (A1,TABLE AARAY, 12,0)

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

 

[Khalid NGO]

Hi,

IF not necessary, try:
=AND(SEARCH(B1,"XXXX", 1)=1,VLOOKUP(A1,TABLE AARAY, 12,0)=1)

or with COUNTIF & wildcard:
=AND(COUNTIF(B1,"*XXXX*")=1,VLOOKUP(A1,TABLE AARAY, 12,0)=1)

Regards,

 

[libin baby]

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,"")

 

[xlstime]

You can add formula in IF condition logical_test part like below

if (or(and(1st__formula,2nd__formula),and(1st__formula,2nd__formula)),true,false)

bold one is old rules.

As suggest by @Khalid, you can also remove IF condition as there is no need to apply if.

formula without if

or(and(1st__formula,2nd__formula),and(1st__formula,2nd__formula))

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,"")