Re: Does anybody know how to VLOOKUP dates without returning
coffee11 said:
the empty fields in the VLOOKUP as 00/01/1900 (I want them to be empty)
If you installed the morefunc add-in...
=IF(ISNA(SETV(VLOOKUP(A8,'PROCESS Trk'!$C$9:$O$53,13,0))),"",IF(GETV(),GETV(),""))
If you can't use morefunc for some reason...
=IF(ISNA(V(VLOOKUP(A8,'PROCESS Trk'!$C$9:$O$53,13,0))),"",IF(V(),V(),""))
What follows is the code for the V() function and instruction how to add it to your workbook:
Public Function V(Optional vrnt As Variant) As Variant
'
' Stephen Dunn
' 2002-09-12
'
Static vrntV As Variant
If Not IsMissing(vrnt) Then vrntV = vrnt
V = vrntV
End Function
To add this to your workbook:
Activate Tools|Macro|Visual Basic Editor;
Activate Insert|Module;
Copy the UDF above and paste it in the pane entitled "...(code)".
Activate File|Close and Return to Microsoft Excel.