Home |
Search |
Today's Posts |
#1
|
|||
|
|||
0/01/1900
i have a VLOOKUP formula which returns a date value and i have formatted the
cells to be in date format. however when a value cannot be found (ie. returns 0) the format changes the 0 to 0/01/1900. how can i stop this? id want the cell to be blank if there is no value. appreciate your help, thanks! |
#2
|
|||
|
|||
Hi
=IF(VLOOKUP(...)=0,"",VLOOKUP(...)) -- When sending mail, use address arvil<attarkon.ee Arvi Laanemets "leolin" wrote in message ... i have a VLOOKUP formula which returns a date value and i have formatted the cells to be in date format. however when a value cannot be found (ie. returns 0) the format changes the 0 to 0/01/1900. how can i stop this? id want the cell to be blank if there is no value. appreciate your help, thanks! |
#3
|
|||
|
|||
I think I'd use:
=if(vlookup()="","",vlookup()) just in case there was ever a zero that should be returned. Arvi Laanemets wrote: Hi =IF(VLOOKUP(...)=0,"",VLOOKUP(...)) -- When sending mail, use address arvil<attarkon.ee Arvi Laanemets "leolin" wrote in message ... i have a VLOOKUP formula which returns a date value and i have formatted the cells to be in date format. however when a value cannot be found (ie. returns 0) the format changes the 0 to 0/01/1900. how can i stop this? id want the cell to be blank if there is no value. appreciate your help, thanks! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|