Is it possible to combine a IF(ISBLANK and IF(ISNA in a formula? - by way of OR statement
This is the following formula I have:
IF(ISNA(VLOOKUP($A3,Range1,,FALSE)),"NA",VLOOKUP($A3,Range1,6,FALSE))
I would like to put the ISBLANK function in it, but not quite sure how to construct properly.
This is the following formula I have:
IF(ISNA(VLOOKUP($A3,Range1,,FALSE)),"NA",VLOOKUP($A3,Range1,6,FALSE))
I would like to put the ISBLANK function in it, but not quite sure how to construct properly.