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?
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?