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

 

[FDibbins]

Just a guess...
=if(iserror(search(B1,"XXXX", 1),"",1
2)VLOOKUP (A1,TABLE AARAY, 12,0)

=IF(and(ISNUMBER(SEARCH("xxx",B1)),VLOOKUP (A1,TABLE AARAY, 12,0)=1),1,"")

 

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

 

[Joe4]

Cross-posted here: Iserror err

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule #13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.