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 the contents of cell A1
If cell A1 is blank and cell B1 is blank, maintain the blank
Is there a way to combine this all into one IF statement?
If you can't return the contents of a cell with an IF statement, what would I use to do that?
There is one more combination, both A1 and B1 are not blank. What then?
Could be
=IF(ISBLANK(A1),IF(ISBLANK(B1),"",VLOOKUP()),IF(ISBLANK(B1),A1,<if both not blank>))