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