Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Vlookup
Hi :) I'm using this lookup to find a date from another tab but I would like
it to leave it blank if there is not a date instead of filling in 1/0/1900? Does anyone know a way to fix this? Thank you!! =VLOOKUP(B4,'Data'!A2:F7863,3,FALSE) |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Vlookup
As the "1/0/1900" is a zero, indicatively,
you could try it like this: =IF(VLOOKUP(...)=0,"",VLOOKUP(...)) which will return "blanks" ie: "" (zero length null strings) where the vlook evaluates to zeros Success? High-five it, click YES below -- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:300 Subscribers:70 xdemechanik --- "H" wrote: Hi :) I'm using this lookup to find a date from another tab but I would like it to leave it blank if there is not a date instead of filling in 1/0/1900? Does anyone know a way to fix this? Thank you!! =VLOOKUP(B4,'Data'!A2:F7863,3,FALSE) |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Vlookup
Hi,
You could apply the following format where the VLOOKUP formula is without needing to modify your formula: m/d/yyyy;; Create this format by choosing Format, Cells, Number tab, Custom and entering it on the Type line. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "H" wrote: Hi :) I'm using this lookup to find a date from another tab but I would like it to leave it blank if there is not a date instead of filling in 1/0/1900? Does anyone know a way to fix this? Thank you!! =VLOOKUP(B4,'Data'!A2:F7863,3,FALSE) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |