# Adding Blank Cell Logic to Existing Formula

#### meppwc

##### Active Member
The formula below that is in W247 works correctly. You will notice if the lookup finds a value (the secondary VLOOKUP logis), that the formula returns the value in column 9.
But if the value for column 9 is blank, then I want blank returned.
Currently Excel is populating the value of "1/0/00"
I am struggling with fitting an ISBLANK condition into this formula.

=IF(D247<>"",D247,IF(ISERROR(VLOOKUP(O247,'G-Block CMO-FMO and IP Ranges '!\$A\$61:\$I\$400,7,FALSE)),"",VLOOKUP(O247,'G-Block CMO-FMO and IP Ranges '!\$A\$61:\$I\$400,9,FALSE)))

### Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

#### Aryatect

##### Active Member
Hi, this is returning value 0 for you and it is in date format m/d/yy.

If you want to change that then without going into too much modification this should work:

Code:
``=IF(D247<>"",D247,IF(ISERROR(VLOOKUP(O247,'G-Block CMO-FMO and IP Ranges'!\$A\$61:\$I\$400,7,FALSE)),"",IF(VLOOKUP(O247,'G-Block CMO-FMO and IP Ranges'!\$A\$61:\$I\$400,9,FALSE)=0,"",VLOOKUP(O247,'G-Block CMO-FMO and IP Ranges'!\$A\$61:\$I\$400,9,FALSE))))``

Last edited:

#### DanteAmor

##### Well-known Member
The formula below that is in W247 works correctly. You will notice if the lookup finds a value (the secondary VLOOKUP logis), that the formula returns the value in column 9.
But if the value for column 9 is blank, then I want blank returned.
Currently Excel is populating the value of "1/0/00"
I am struggling with fitting an ISBLANK condition into this formula.

Apparently you have a date format in the cell.
Change the format of the cell to:

dd/mm/aaaa;;"";@

https://support.microsoft.com/en-us...stand-settings-in-the-format-cells-dialog-box

#### Aryatect

##### Active Member
You can also change the format of Column W to m/d/yy;"";

#### DanteAmor

##### Well-known Member
it is correct must be yyyy then

dd/mm/yyyy;;"";@

#### meppwc

##### Active Member
Thank you all for the assistance.........DanteAmor.........dd/mm/aaaa;;"";@ worked perfectly. It really "cleaned" things up.

#### DanteAmor

##### Well-known Member
Thank you all for the assistance.........DanteAmor.........dd/mm/aaaa;;"";@ worked perfectly. It really "cleaned" things up.

1,102,384
Messages
5,486,542
Members
407,550
Latest member
LucasBordure