How use multiple IF

[Bany26]

Dear all,

can you please help add one more ''IF'' function into the following string.

Currently I am using this, and it is working fine:
=IF(ISERR(SEARCH(A1,Sheet2!B:B)),"",VLOOKUP(C1,Sheet2!A:D,4,FALSE))

however I would like to add one more IF condition into the above string -> (ISERR(SEARCH(B1,Sheet2!C:C)),""

so VLOOKUP should return results only when both IF conditions will return value.
can you please help?

 

[Special-K99]

=IF(AND(NOT(ISERR(SEARCH(A1,Sheet2!B:B))),NOT(ISERR(SEARCH(B1,Sheet2!C:C)))),"",VLOOKUP(C1,Sheet2!A:D,4,FALSE))

though I prefer

=IF(AND(ISNUMBER(SEARCH(A1,Sheet2!B:B)),ISNUMBER(SEARCH(B1,Sheet2!C:C))),"",VLOOKUP(C1,Sheet2!A:D,4,FALSE))

 

[Bany26]

thanks Special-K99 for your advice, I have slightly amended the string and it works perfectly.

=IF(AND(ISERR(SEARCH(A1,Sheet2!B:B)),ISERR(SEARCH(B1,Sheet2!C:C)))),"",(VLOOKUP(C1,Sheet2!A:D,4,FALSE)))