Spreadsheet: 88421d1288257420-vlookup-date-problem-sample
Sheet: Sheet1

 |  |  |  |  |  |  |  | Combo box lists |  |  | 1 | Combo box links
 |  |  |  |  |  |  |  | Day | Month | Year | 3
 | 2010-01-01 00:00:00 | 1 |  |  |  |  |  | 1 | 01 | 2007 | 4
 | 2010-01-02 00:00:00 | 2 |  | 1/03/2010 |  | #N/A |  | 2 | 02 | 2008
 | 2010-01-03 00:00:00 | 3 |  |  |  |  |  | 3 | 03 | 2009
 | 2010-01-04 00:00:00 | 4 |  | 1/03/2010 |  | #N/A |  | 4 | 04 | 2010
 | 2010-01-05 00:00:00 | 5 |  |  |  |  |  | 5 | 05 | 2011
 | 2010-01-06 00:00:00 | 6 |  |  |  |  |  | 6 | 06
 | 2010-01-07 00:00:00 | 7 |  |  |  |  |  | 7 | 07
 | 2010-01-08 00:00:00 | 8 |  |  |  |  |  | 8 | 08
 | 2010-01-09 00:00:00 | 9 |  |  |  |  |  | 9 | 09
 | 2010-01-10 00:00:00 | 10 |  |  |  |  |  | 10 | 10
 | 2010-01-11 00:00:00 | 11 |  |  |  |  |  | 11 | 11
 | 2010-01-12 00:00:00 | 12 |  |  |  |  |  | 12 | 12
 | 2010-01-13 00:00:00 | 13 |  |  |  |  |  | 13 | Jan
 | 2010-01-14 00:00:00 | 14 |  |  |  |  |  | 14 | Feb
 | 2010-01-15 00:00:00 | 15 |  |  |  |  |  | 15 | Mar
 | 2010-01-16 00:00:00 | 16 |  |  |  |  |  | 16 | Apr
 | 2010-01-17 00:00:00 | 17 |  |  |  |  |  | 17 | May
 | 2010-01-18 00:00:00 | 18 |  |  |  |  |  | 18 | Jun
 | 2010-01-19 00:00:00 | 19 |  |  |  |  |  | 19 | Jul
 | 2010-01-20 00:00:00 | 20 |  |  |  |  |  | 20 | Aug
 | 2010-01-21 00:00:00 | 21 |  |  |  |  |  | 21 | Sep
 | 2010-01-22 00:00:00 | 22 |  |  |  |  |  | 22 | Oct
 | 2010-01-23 00:00:00 | 23 |  |  |  |  |  | 23 | Nov
 | 2010-01-24 00:00:00 | 24 |  |  |  |  |  | 24 | Dec
 | 2010-01-25 00:00:00 | 25 |  |  |  |  |  | 25
 | 2010-01-26 00:00:00 | 26 |  |  |  |  |  | 26
 | 2010-01-27 00:00:00 | 27 |  |  |  |  |  | 27
 | 2010-01-28 00:00:00 | 28 |  |  |  |  |  | 28
 | 2010-01-29 00:00:00 | 29 |  |  |  |  |  | 29
 | 2010-01-30 00:00:00 | 30 |  |  |  |  |  | 30
 | 2010-01-31 00:00:00 | 31 |  |  |  |  |  | 31
 | 2010-02-01 00:00:00 | 32
 | 2010-02-02 00:00:00 | 33
 | 2010-02-03 00:00:00 | 34
 | 2010-02-04 00:00:00 | 35
 | 2010-02-05 00:00:00 | 36
 | 2010-02-06 00:00:00 | 37
 | 2010-02-07 00:00:00 | 38
 | 2010-02-08 00:00:00 | 39
 | 2010-02-09 00:00:00 | 40
 | 2010-02-10 00:00:00 | 41
 | 2010-02-11 00:00:00 | 42
 | 2010-02-12 00:00:00 | 43
 | 2010-02-13 00:00:00 | 44
 | 2010-02-14 00:00:00 | 45
 | 2010-02-15 00:00:00 | 46
 | 2010-02-16 00:00:00 | 47
 | 2010-02-17 00:00:00 | 48
 | 2010-02-18 00:00:00 | 49
 | 2010-02-19 00:00:00 | 50
 | 2010-02-20 00:00:00 | 51
 | 2010-02-21 00:00:00 | 52
 | 2010-02-22 00:00:00 | 53
 | 2010-02-23 00:00:00 | 54
 | 2010-02-24 00:00:00 | 55
 | 2010-02-25 00:00:00 | 56
 | 2010-02-26 00:00:00 | 57
 | 2010-02-27 00:00:00 | 58
 | 2010-02-28 00:00:00 | 59
 | 2010-03-01 00:00:00 | 60
 | 2010-03-02 00:00:00 | 61
 | 2010-03-03 00:00:00 | 62
 | 2010-03-04 00:00:00 | 63
 | 2010-03-05 00:00:00 | 64
 | 2010-03-06 00:00:00 | 65
 | 2010-03-07 00:00:00 | 66
 | 2010-03-08 00:00:00 | 67
 | 2010-03-09 00:00:00 | 68
 | 2010-03-10 00:00:00 | 69
 | 2010-03-11 00:00:00 | 70
 | 2010-03-12 00:00:00 | 71
 | 2010-03-13 00:00:00 | 72
 | 2010-03-14 00:00:00 | 73
 | 2010-03-15 00:00:00 | 74
 | 2010-03-16 00:00:00 | 75
 | 2010-03-17 00:00:00 | 76
 | 2010-03-18 00:00:00 | 77
 | 2010-03-19 00:00:00 | 78
 | 2010-03-20 00:00:00 | 79
 | 2010-03-21 00:00:00 | 80
 | 2010-03-22 00:00:00 | 81
 | 2010-03-23 00:00:00 | 82
 | 2010-03-24 00:00:00 | 83
 | 2010-03-25 00:00:00 | 84
 | 2010-03-26 00:00:00 | 85
 | 2010-03-27 00:00:00 | 86
 | 2010-03-28 00:00:00 | 87
 | 2010-03-29 00:00:00 | 88
 | 2010-03-30 00:00:00 | 89
 | 2010-03-31 00:00:00 | 90
 | 2010-04-01 00:00:00 | 91
 | 2010-04-02 00:00:00 | 92
 | 2010-04-03 00:00:00 | 93
 | 2010-04-04 00:00:00 | 94
 | 2010-04-05 00:00:00 | 95
 | 2010-04-06 00:00:00 | 96
 | 2010-04-07 00:00:00 | 97
 | 2010-04-08 00:00:00 | 98
 | 2010-04-09 00:00:00 | 99
 | 2010-04-10 00:00:00 | 100
 | 2010-04-11 00:00:00 | 101
 | 2010-04-12 00:00:00 | 102
 | 2010-04-13 00:00:00 | 103
 | 2010-04-14 00:00:00 | 104
 | 2010-04-15 00:00:00 | 105
 | 2010-04-16 00:00:00 | 106
 | 2010-04-17 00:00:00 | 107
 | 2010-04-18 00:00:00 | 108
 | 2010-04-19 00:00:00 | 109
 | 2010-04-20 00:00:00 | 110
 | 2010-04-21 00:00:00 | 111
 | 2010-04-22 00:00:00 | 112
 | 2010-04-23 00:00:00 | 113
 | 2010-04-24 00:00:00 | 114
 | 2010-04-25 00:00:00 | 115
 | 2010-04-26 00:00:00 | 116
 | 2010-04-27 00:00:00 | 117
 | 2010-04-28 00:00:00 | 118
 | 2010-04-29 00:00:00 | 119
 | 2010-04-30 00:00:00 | 120
 | 2010-05-01 00:00:00 | 121
 | 2010-05-02 00:00:00 | 122
 | 2010-05-03 00:00:00 | 123
 | 2010-05-04 00:00:00 | 124
 | 2010-05-05 00:00:00 | 125
 | 2010-05-06 00:00:00 | 126
 | 2010-05-07 00:00:00 | 127
 | 2010-05-08 00:00:00 | 128
 | 2010-05-09 00:00:00 | 129
 | 2010-05-10 00:00:00 | 130
 | 2010-05-11 00:00:00 | 131
 | 2010-05-12 00:00:00 | 132
 | 2010-05-13 00:00:00 | 133
 | 2010-05-14 00:00:00 | 134
 | 2010-05-15 00:00:00 | 135
 | 2010-05-16 00:00:00 | 136
 | 2010-05-17 00:00:00 | 137
 | 2010-05-18 00:00:00 | 138
 | 2010-05-19 00:00:00 | 139
 | 2010-05-20 00:00:00 | 140
 | 2010-05-21 00:00:00 | 141
 | 2010-05-22 00:00:00 | 142
 | 2010-05-23 00:00:00 | 143
 | 2010-05-24 00:00:00 | 144
 | 2010-05-25 00:00:00 | 145
 | 2010-05-26 00:00:00 | 146
 | 2010-05-27 00:00:00 | 147
 | 2010-05-28 00:00:00 | 148
 | 2010-05-29 00:00:00 | 149
 | 2010-05-30 00:00:00 | 150
 | 2010-05-31 00:00:00 | 151
 | 2010-06-01 00:00:00 | 152
 | 2010-06-02 00:00:00 | 153
 | 2010-06-03 00:00:00 | 154
 | 2010-06-04 00:00:00 | 155
 | 2010-06-05 00:00:00 | 156
 | 2010-06-06 00:00:00 | 157
 | 2010-06-07 00:00:00 | 158
 | 2010-06-08 00:00:00 | 159
 | 2010-06-09 00:00:00 | 160
 | 2010-06-10 00:00:00 | 161
 | 2010-06-11 00:00:00 | 162
 | 2010-06-12 00:00:00 | 163
 | 2010-06-13 00:00:00 | 164
 | 2010-06-14 00:00:00 | 165
 | 2010-06-15 00:00:00 | 166
 | 2010-06-16 00:00:00 | 167
 | 2010-06-17 00:00:00 | 168
 | 2010-06-18 00:00:00 | 169
 | 2010-06-19 00:00:00 | 170
 | 2010-06-20 00:00:00 | 171
 | 2010-06-21 00:00:00 | 172
 | 2010-06-22 00:00:00 | 173
 | 2010-06-23 00:00:00 | 174
 | 2010-06-24 00:00:00 | 175
 | 2010-06-25 00:00:00 | 176
 | 2010-06-26 00:00:00 | 177
 | 2010-06-27 00:00:00 | 178
 | 2010-06-28 00:00:00 | 179
 | 2010-06-29 00:00:00 | 180
 | 2010-06-30 00:00:00 | 181
 | 2010-07-01 00:00:00 | 182
 | 2010-07-02 00:00:00 | 183
 | 2010-07-03 00:00:00 | 184
 | 2010-07-04 00:00:00 | 185
 | 2010-07-05 00:00:00 | 186
 | 2010-07-06 00:00:00 | 187
 | 2010-07-07 00:00:00 | 188
 | 2010-07-08 00:00:00 | 189
 | 2010-07-09 00:00:00 | 190
 | 2010-07-10 00:00:00 | 191
 | 2010-07-11 00:00:00 | 192
 | 2010-07-12 00:00:00 | 193
 | 2010-07-13 00:00:00 | 194
 | 2010-07-14 00:00:00 | 195
 | 2010-07-15 00:00:00 | 196
 | 2010-07-16 00:00:00 | 197
 | 2010-07-17 00:00:00 | 198
 | 2010-07-18 00:00:00 | 199
 | 2010-07-19 00:00:00 | 200
 | 2010-07-20 00:00:00 | 201
 | 2010-07-21 00:00:00 | 202
 | 2010-07-22 00:00:00 | 203
 | 2010-07-23 00:00:00 | 204
 | 2010-07-24 00:00:00 | 205
 | 2010-07-25 00:00:00 | 206
 | 2010-07-26 00:00:00 | 207
 | 2010-07-27 00:00:00 | 208
 | 2010-07-28 00:00:00 | 209
 | 2010-07-29 00:00:00 | 210
 | 2010-07-30 00:00:00 | 211
 | 2010-07-31 00:00:00 | 212
 | 2010-08-01 00:00:00 | 213
 | 2010-08-02 00:00:00 | 214
 | 2010-08-03 00:00:00 | 215
 | 2010-08-04 00:00:00 | 216
 | 2010-08-05 00:00:00 | 217
 | 2010-08-06 00:00:00 | 218
 | 2010-08-07 00:00:00 | 219
 | 2010-08-08 00:00:00 | 220
 | 2010-08-09 00:00:00 | 221
 | 2010-08-10 00:00:00 | 222
 | 2010-08-11 00:00:00 | 223
 | 2010-08-12 00:00:00 | 224
 | 2010-08-13 00:00:00 | 225
 | 2010-08-14 00:00:00 | 226
 | 2010-08-15 00:00:00 | 227
 | 2010-08-16 00:00:00 | 228
 | 2010-08-17 00:00:00 | 229
 | 2010-08-18 00:00:00 | 230
 | 2010-08-19 00:00:00 | 231
 | 2010-08-20 00:00:00 | 232
 | 2010-08-21 00:00:00 | 233
 | 2010-08-22 00:00:00 | 234
 | 2010-08-23 00:00:00 | 235
 | 2010-08-24 00:00:00 | 236
 | 2010-08-25 00:00:00 | 237
 | 2010-08-26 00:00:00 | 238
 | 2010-08-27 00:00:00 | 239
 | 2010-08-28 00:00:00 | 240
 | 2010-08-29 00:00:00 | 241
 | 2010-08-30 00:00:00 | 242
 | 2010-08-31 00:00:00 | 243
 | 2010-09-01 00:00:00 | 244
 | 2010-09-02 00:00:00 | 245
 | 2010-09-03 00:00:00 | 246
 | 2010-09-04 00:00:00 | 247
 | 2010-09-05 00:00:00 | 248
 | 2010-09-06 00:00:00 | 249
 | 2010-09-07 00:00:00 | 250
 | 2010-09-08 00:00:00 | 251
 | 2010-09-09 00:00:00 | 252
 | 2010-09-10 00:00:00 | 253
 | 2010-09-11 00:00:00 | 254
 | 2010-09-12 00:00:00 | 255
 | 2010-09-13 00:00:00 | 256
 | 2010-09-14 00:00:00 | 257
 | 2010-09-15 00:00:00 | 258
 | 2010-09-16 00:00:00 | 259
 | 2010-09-17 00:00:00 | 260
 | 2010-09-18 00:00:00 | 261
 | 2010-09-19 00:00:00 | 262
 | 2010-09-20 00:00:00 | 263
 | 2010-09-21 00:00:00 | 264
 | 2010-09-22 00:00:00 | 265
 | 2010-09-23 00:00:00 | 266
 | 2010-09-24 00:00:00 | 267
 | 2010-09-25 00:00:00 | 268
 | 2010-09-26 00:00:00 | 269
 | 2010-09-27 00:00:00 | 270
 | 2010-09-28 00:00:00 | 271
 | 2010-09-29 00:00:00 | 272
 | 2010-09-30 00:00:00 | 273
 | 2010-10-01 00:00:00 | 274
 | 2010-10-02 00:00:00 | 275
 | 2010-10-03 00:00:00 | 276
 | 2010-10-04 00:00:00 | 277
 | 2010-10-05 00:00:00 | 278
 | 2010-10-06 00:00:00 | 279
 | 2010-10-07 00:00:00 | 280
 | 2010-10-08 00:00:00 | 281
 | 2010-10-09 00:00:00 | 282
 | 2010-10-10 00:00:00 | 283
 | 2010-10-11 00:00:00 | 284
 | 2010-10-12 00:00:00 | 285
 | 2010-10-13 00:00:00 | 286
 | 2010-10-14 00:00:00 | 287
 | 2010-10-15 00:00:00 | 288
 | 2010-10-16 00:00:00 | 289
 | 2010-10-17 00:00:00 | 290
 | 2010-10-18 00:00:00 | 291
 | 2010-10-19 00:00:00 | 292
 | 2010-10-20 00:00:00 | 293
 | 2010-10-21 00:00:00 | 294
 | 2010-10-22 00:00:00 | 295
 | 2010-10-23 00:00:00 | 296
 | 2010-10-24 00:00:00 | 297
 | 2010-10-25 00:00:00 | 298
 | 2010-10-26 00:00:00 | 299
 | 2010-10-27 00:00:00 | 300
 | 2010-10-28 00:00:00 | 301
 | 2010-10-29 00:00:00 | 302
 | 2010-10-30 00:00:00 | 303
 | 2010-10-31 00:00:00 | 304
 | 2010-11-01 00:00:00 | 305
 | 2010-11-02 00:00:00 | 306
 | 2010-11-03 00:00:00 | 307
 | 2010-11-04 00:00:00 | 308
 | 2010-11-05 00:00:00 | 309
 | 2010-11-06 00:00:00 | 310
 | 2010-11-07 00:00:00 | 311
 | 2010-11-08 00:00:00 | 312
 | 2010-11-09 00:00:00 | 313
 | 2010-11-10 00:00:00 | 314
 | 2010-11-11 00:00:00 | 315
 | 2010-11-12 00:00:00 | 316
 | 2010-11-13 00:00:00 | 317
 | 2010-11-14 00:00:00 | 318
 | 2010-11-15 00:00:00 | 319
 | 2010-11-16 00:00:00 | 320
 | 2010-11-17 00:00:00 | 321
 | 2010-11-18 00:00:00 | 322
 | 2010-11-19 00:00:00 | 323
 | 2010-11-20 00:00:00 | 324
 | 2010-11-21 00:00:00 | 325
 | 2010-11-22 00:00:00 | 326
 | 2010-11-23 00:00:00 | 327
 | 2010-11-24 00:00:00 | 328
 | 2010-11-25 00:00:00 | 329
 | 2010-11-26 00:00:00 | 330
 | 2010-11-27 00:00:00 | 331
 | 2010-11-28 00:00:00 | 332
 | 2010-11-29 00:00:00 | 333
 | 2010-11-30 00:00:00 | 334
 | 2010-12-01 00:00:00 | 335
 | 2010-12-02 00:00:00 | 336
 | 2010-12-03 00:00:00 | 337
 | 2010-12-04 00:00:00 | 338
 | 2010-12-05 00:00:00 | 339
 | 2010-12-06 00:00:00 | 340
 | 2010-12-07 00:00:00 | 341
 | 2010-12-08 00:00:00 | 342
 | 2010-12-09 00:00:00 | 343
 | 2010-12-10 00:00:00 | 344
 | 2010-12-11 00:00:00 | 345
 | 2010-12-12 00:00:00 | 346
 | 2010-12-13 00:00:00 | 347
 | 2010-12-14 00:00:00 | 348
 | 2010-12-15 00:00:00 | 349
 | 2010-12-16 00:00:00 | 350
 | 2010-12-17 00:00:00 | 351
 | 2010-12-18 00:00:00 | 352
 | 2010-12-19 00:00:00 | 353
 | 2010-12-20 00:00:00 | 354
 | 2010-12-21 00:00:00 | 355
 | 2010-12-22 00:00:00 | 356
 | 2010-12-23 00:00:00 | 357
 | 2010-12-24 00:00:00 | 358
 | 2010-12-25 00:00:00 | 359
 | 2010-12-26 00:00:00 | 360
 | 2010-12-27 00:00:00 | 361
 | 2010-12-28 00:00:00 | 362
 | 2010-12-29 00:00:00 | 363
 | 2010-12-30 00:00:00 | 364
 | 2010-12-31 00:00:00 | 365