Forum Discussion
. .
Mar 12, 2018Copper Contributor
IF function with ISBlank
I am trying to write an if statement to achieve the following If cell A1 is blank and cell B1 is not blank, vlookup cell B1 in (Table Name) If cell A1 is not blank and cell B1 is blank, return th...
SergeiBaklan
Mar 12, 2018MVP
Could be
=IF(ISBLANK(A1),IF(ISBLANK(B1),"",VLOOKUP()),IF(ISBLANK(B1),A1,<if both not blank>))