Spreadsheet: 681330d1591484181-vlookup-to-results-of-formula-with-numbers-and-letters-vlookup-for-vins
Sheet: Garage

Last 8 | STOCK# | PURCHASED FROM: | YR/MAKE | STYLE | VIN | COLOUR | DATE IN | DATE OUT | SOLD TO: | Associate ID | ADDRESS | KMS
 | 20P269 | KIA CANADA | 2020 KIA | SPORTAGE LX AWD | KNDPMCACXL7808221 | MODERN BRONZE | 2020-03-18 00:00:00 | 2020-05-08 00:00:00 | Me | 12121 | Gatineau, QC | 11
 | 20P270 | KIA CANADA | 2020 KIA | SPORTAGE LX AWD | KNDPMCAC6L7808734 | STORM BLUE | 2020-03-18 00:00:00 | 2020-06-01 00:00:00 | You | 121215 | Kingston, ON | 10
 | 20P271 | KIA CANADA | 2020 KIA | FORTE EX PREMIUM | 3KPF54AD1LE226662 | GRAVITY GREY | 2020-03-18 00:00:00
 | 20P272 | KIA CANADA | 2020 KIA | FORTE EX+ | 3KPF54AD4LE232794 | GRAVITY GREY | 2020-04-01 00:00:00
 | 20P273 | KIA CANADA | 2020 KIA | SORENTO LX+ [NAME] | 5XYPGDA55LG687633 | EBONY BLACK | 2020-04-01 00:00:00
 | 20P274 | KIA CANADA | 2020 KIA | SORENTO LX+ [NAME] | 5XYPGDA56LG687544 | GRAVITY GREY | 2020-04-01 00:00:00
 | 20P275 | KIA CANADA | 2020 KIA | FORTE EX+ | 3KPF54AD8LE231485 | AURORA BLACK | 2020-04-01 00:00:00 | 2020-05-29 00:00:00 | Them | 125459 | [NAME], ON | 26
 | 20P276 | KIA CANADA | 2020 KIA | FORTE EX+ | 3KPF54ADXLE232606 | [NAME] | 2020-04-01 00:00:00
 | 20P277 | KIA CANADA | 2020 KIA | SEDONA SX TECH | KNDMC5C13L6649593 | SNOW WHITE PEARL | 2020-04-22 00:00:00 | 2020-04-23 00:00:00 | Her | 125386 | Rockland, ON | 10
 | 20P278 | KIA CANADA | 2020 KIA | SPORTAGE EX | KNDPNCAC2L7813233 | SCARLET RED | 2020-05-06 00:00:00 | 2020-05-26 00:00:00 | Her again |  | JOLIETTE, QC | 10
 | 20P279 | KIA CANADA | 2020 KIA | SPORTAGE EX 'S' | KNDPNCAC4L7820748 | SNOW WHITE PEARL | 2020-05-12 00:00:00 | 2020-05-21 00:00:00 | YOUAgain | 125423 | Almonte, ON | 24
 | 20P280 | KIA CANADA | 2020 KIA | SPORTAGE EX 'S' | KNDPNCAC2L7819131 | SCARLET RED | 2020-05-12 00:00:00 | 2020-06-03 00:00:00 | Test1 | 111257 | Perth, ON | 33
 | 20P281 | KIA CANADA | 2020 KIA | TELLURIDE SX | 5XYP5DHC5LG086491 | DARK MOSS | 2020-05-12 00:00:00
 | 20P282 | KIA CANADA | 2020 KIA | SPORTAGE EX | KNDPNCACXL7821130 | SNOW WHITE PEARL | 2020-05-12 00:00:00 | 2020-05-22 00:00:00 | Test2 | 125440 | Stittsville, ON | 41
 | 20DT283 | KIA OF BROCKVILLE | 2020 KIA | SPORTAGE LX FWD | [NAME] | BLACK CHERRY | 2020-05-13 00:00:00 | 2020-05-22 00:00:00 | Test 3 | 121495 | [NAME], ON | 186
 | 20P284 | KIA CANADA | 2020 KIA | TELLURIDE SX | 5XYP5DHC6LG087293 | GRAVITY GREY | 2020-05-12 00:00:00
 | 20DT285 | [NAME] | 2020 KIA | SOUL EX | KNDJ33AU3L7121356 | INFERNO RED | 2020-05-25 00:00:00
 | 20P286 | KIA CANADA | 2020 KIA | SOUL EX | KNDJ33AU0L7121136 | LUNAR ORANGE | 2020-05-25 00:00:00
 | 20P287 | KIA CANADA | 2020 KIA | SOUL EX | KNDJ33AU7L7121098 | LUNAR ORANGE | 2020-05-25 00:00:00 | 2020-06-03 00:00:00 | Somplace | 21211 | Gatineau, Qc | 10
 | 20P288 | KIA CANADA | 2020 KIA | SOUL EX | KNDJ33AU7L7121358 | INFERNO RED | 2020-05-25 00:00:00
 | 20P289 | KIA CANADA | 2020 KIA | SORENTO EX | 5XYPHDA52LG654330 | EVERLASTING GREY | 2020-05-26 00:00:00
 | 20P290 | KIA CANADA | 2020 KIA | SORENTO EX | 5XYPHDA51LG651743 | SNOW WHITE PEARL | 2020-05-26 00:00:00 | 2020-05-28 00:00:00 | Noupe | 12121 | Brockville, ON | 10