Here is the formula I use:
=IF(ISERROR(VLOOKUP(H5;SHEET2!B:AB;3;FALSE));"";VLOOKUP(H5;SHEET2!B:AB;3;FALSE))
I would need to use that same formula based on 2 lookup value:
IF cell F5 is empty "" Then use that formula:
=IF(ISERROR(VLOOKUP(H5;SHEET2!B:AB;3;FALSE));"";VLOOKUP(H5;SHEET2!B:AB;3;FALSE))
BUT IF cell F5 is NOT empty or IF H5 is empty then use that formula:
=IF(ISERROR(VLOOKUP(F5;SHEET2!B:AB;3;FALSE));"";VLOOKUP(F5;SHEET2!B:AB;3;FALSE))
How could I combine these two formula?
Many thanks in advance,
Graig
Bookmarks