Spreadsheet: 794506d1662085154-need-to-create-a-list-based-on-a-value-in-specific-column-tip-worksheeet
Sheet: Data Input

Make | Model | Year | Trim | Condition | VIN | Stock# | Price | Deal Rating | New Price | New Deal Rating | CarGurus IMV | Price Change | Price Change to Next Best Deal Rating | Price at Next Deal Rating | Days at Dealership | Days on CarGurus
BMW | X3 | 2018 | xDrive30i AWD | used | 5UXTR9C5XJLC75410 | JLC75410A | 30444 | Great Deal |  |  | 33856 |  |  |  | 81 | 81
Subaru | Ascent | 2019 | Limited 7-Passenger AWD | used | 4S4WMAPD0K3418455 | [NAME] | 33672 | Great Deal |  |  | 35921 |  |  |  | 28 | 28
RAM | 1500 | 2019 | Classic SLT Crew Cab LB RWD | used | 1C6RR6TT4KS697192 | PKS697192 | 26900 | Great Deal |  |  | 29673 |  |  |  | 8 | 8
Ford | F-250 Super Duty | 2015 | Platinum Crew Cab LB 4WD | used | 1FT7W2BT0FEC11971 | FEC11971A | 50900 | Great Deal |  |  | 54250 |  |  |  | 36 | 36
Dodge | Charger | 2019 | SXT RWD | used | 2C3CDXBG6KH748193 | PKH748193 | 24900 | Great Deal |  |  | 27046 |  |  |  | 159 | 191
Chevrolet | Camaro | 2019 | 1LT [NAME] | used | 1G1FB3DS3K0107444 | PK0107444 | 25900 | Great Deal |  |  | 27706 |  |  |  | 106 | 106
Chevrolet | Camaro | 2014 | 2LS Coupe RWD | used | 2G1FA1E32E9135065 | E9135065A | 16900 | Good Deal | 16550 | Great Deal | 18126 | -350 | 262 | 16638 | 75 | 75
Cadillac | XT4 | 2020 | Luxury FWD | used | 1GYAZAR40LF000002 | LF000002A | 32750 | Good Deal | 32571 | Good Deal | 34042 | -179 | 342 | 32408 | 62 | 62
Toyota | Tacoma | 2019 | [NAME] | cpo | 5TFAZ5CN6KX084186 | KX084186A | 35900 | Good Deal |  |  | 37596 |  | 524 | 35376 | 71 | 71
Dodge | [NAME] | 2019 | SXT FWD | used | 2C4RDGCG0KR790101 | PKR790101 | 19800 | Good Deal |  |  | 21708 |  | 1579 | 18221 | 149 | 149
Toyota | Tundra | 2018 | SR5 CrewMax 5.7L | used | 5TFEY5F10JX243599 | JX243599A | 36900 | Good Deal |  |  | 37957 |  | 884 | 36016 | 4 | 4
Toyota | RAV4 | 2016 | LE | used | JTMZFREV7GJ095286 | PGJ095286 | 20482 | Good Deal |  |  | 21148 |  | 606 | 19876 | 9 | 9
Toyota | Corolla | 2022 | LE FWD | cpo | 5YFVPMAE7NP327429 | TNP327429 | 27499 | Good Deal |  |  | 28290 |  | 935 | 26564 | 6 | 6
Toyota | Highlander | 2021 | LE AWD | cpo | 5TDBZRBH5MS092313 | PMS092313 | 36900 | Good Deal |  |  | 37673 |  | 981 | 35919 | 76 | 76
Dodge | [NAME] | 2019 | SXT FWD | used | 2C4RDGCGXKR661802 | PKR661802 | 20900 | Good Deal |  |  | 22265 |  | 2122 | 18778 | 159 | 159
Nissan | Pathfinder | 2020 | SL FWD | used | 5N1DR2CNXLC608925 | PLC608925 | 27200 | Good Deal |  |  | 27962 |  | 1186 | 26014 | 43 | 43
Toyota | Corolla | 2022 | LE FWD | cpo | 5YFVPMAE1NP328592 | TNP328592 | 27499 | Good Deal |  |  | 28109 |  | 1116 | 26383 | 6 | 6
Toyota | Camry | 2022 | XSE FWD | cpo | 4T1K61AK0NU009399 | NU009399A | 39999 | Good Deal |  |  | 40698 |  | 1346 | 38653 | 24 | 24
Toyota | Camry | 2022 | XSE V6 FWD | cpo | 4T1KZ1AK8NU062312 | NU062312A | 42900 | Good Deal |  |  | 43710 |  | 1756 | 41144 | 27 | 27
Cadillac | Escalade ESV | 2020 | Luxury 4WD | used | 1GYS4HKJ0LR278988 | PLR278988 | 62800 | Good Deal | 62695 | Good Deal | 63799 | -105 | 2305 | 60495 | 70 | 70
Ford | Expedition | 2020 | MAX Limited RWD | used | 1FMJK1KT9LEA40107 | PLEA40107 | 40900 | Good Deal |  |  | 42478 |  | 2145 | 38755 | 2 | 2
Toyota | Tacoma | 2021 |  | cpo | 5TFAX5GN7MX192271 | MX192271A | 32999 | Good Deal |  |  | 33938 |  | 2462 | 30537 | 7 | 7
Ford | Explorer | 2019 | Sport AWD | used | 1FM5K8GT1KGB51630 | KGB51630A | 34700 | Good Deal |  |  | 35269 |  | 1615 | 33085 | 219 | 219
Toyota | RAV4 | 2020 | XLE AWD | cpo | 2T3P1RFV0LC089282 | PLC089282 | 30900 | Good Deal | 30602 | Good Deal | 31370 | -298 | 1426 | 29474 | 7 | 7
Chevrolet | Colorado | 2020 | LT [NAME] | used | 1GCGSCEN3L1126138 | PL1126138 | 27400 | Good Deal |  |  | 28285 |  | 1440 | 25960 | 7 | 7
Ford | [NAME] | 2019 | XLT SuperCrew RWD | used | 1FTEW1C52KKC09913 | KKC09913A | 35616 | Good Deal |  |  | 36115 |  | 2259 | 33357 | 1 | 1
Volvo | XC60 | 2020 | T5 Momentum AWD | used | YV4102RK7L1584414 | PL1584414 | 35499 | Good Deal |  |  | 35867 |  | 1367 | 34132 | 90 | 90
Ford | [NAME] | 2018 | Lariat SuperCrew RWD | used | 1FTEW1CP5JFC70861 | JFC70861A | 29999 | Good Deal |  |  | 30665 |  | 2580 | 27419 | 6 | 6
Ford | Fusion | 2020 | SEL FWD | used | 3FA6P0CD3LR177818 | PLR177818 | 23400 | Good Deal |  |  | 23787 |  | 1519 | 21881 | 91 | 91
Ford | Fusion | 2020 | SEL FWD | used | 3FA6P0CD7LR136754 | PLR136754 | 22900 | Good Deal |  |  | 23276 |  | 1530 | 21370 | 77 | 77
Nissan | Frontier | 2019 | SV V6 Crew [NAME] | used | 1N6AD0ER2KN790484 | PKN790484 | 25870 | Good Deal |  |  | 26188 |  | 1527 | 24343 | 34 | 34
Toyota | Tacoma | 2022 | SR5 V6 Double Cab RWD | used | 3TMAZ5CN3NM177371 | NM177371A | 38900 | Good Deal |  |  | 39249 |  | 1821 | 37079 | 37 | 37
Toyota | [NAME] | 2017 | L 7-Passenger FWD | cpo | 5TDZZ3DC6HS872632 | HS872632A | 26838 | Good Deal | 26803 | Good Deal | 27366 | -35 | 2883 | 23955 | 44 | 44
Jeep | [NAME] | 2020 | Sport S 4WD | used | 1C4HJXDN8LW220745 | PLW220745 | 37900 | Good Deal | 37811 | Good Deal | 38239 | -89 | 2209 | 35691 | 30 | 30
Toyota | Tacoma | 2021 | [NAME] | used | 5TFAZ5CN7MX105050 | MX105050A | 40999 | Good Deal |  |  | 41267 |  | 1973 | 39026 | 2 | 2
Toyota | Highlander | 2020 | XLE FWD | cpo | 5TDGZRAH3LS001240 | PLS001240 | 36900 | Fair Deal |  |  | 37049 |  | 94 | 36806 | 72 | 72
Ford | [NAME] | 2019 | SEL FWD | used | 1FMCU0HD9KUC03243 | KUC03243A | 23490 | Fair Deal | 23275 | Good Deal | 23602 | -215 | 84 | 23406 | 15 | 15
Toyota | RAV4 | 2020 | XLE FWD | cpo | 2T3W1RFV3LW085527 | PLW085527 | 32994 | Fair Deal | 32857 | Good Deal | 33098 | -137 | 126 | 32868 | 14 | 14
Ford | Fusion | 2020 | SEL FWD | used | 3FA6P0CD3LR207836 | PLR207836 | 23900 | Fair Deal |  |  | 23928 |  | 197 | 23703 | 63 | 363
Jeep | Gladiator | 2020 | [NAME] | used | 1C6JJTBGXLL184581 | PLL184581 | 45400 | Fair Deal | 45180 | Fair Deal | 45448 | -220 | 417 | 44983 | 77 | 174
Volkswagen | Jetta | 2021 | 1.4T S FWD | used | 3VWC57BU8MM048594 | PMM048594 | 23400 | Fair Deal | 23224 | Good Deal | 23413 | -176 | 164 | 23236 | 29 | 29
Toyota | 4Runner | 2021 | SR5 4WD | cpo | JTEMU5JR9M5901632 | PM5901632 | 39453 | Fair Deal |  |  | 39460 |  | 266 | 39187 | 23 | 23
Chevrolet | Camaro | 2017 | 1LT [NAME] | used | 1G1FB1RS4H0203136 | PH0203136 | 26900 | Fair Deal | 26802 | Fair Deal | 26901 | -98 | 187 | 26713 | 94 | 94
Toyota | [NAME] | 2019 | LE 8-Passenger FWD | used | 5TDKZ3DC7KS978807 | KS978807A | 28509 | Fair Deal |  |  | 28138 |  | 758 | 27751 | 68 | 68
Ford | Flex | 2019 | SEL AWD | used | 2FMHK6C89KBA15465 | PKBA15465 | 28111 | Fair Deal |  |  | 27760 |  | 615 | 27496 | 41 | 41
Mazda | CX-5 | 2021 | Touring FWD | used | JM3KFACM5M0327745 | PM0327745 | 25900 | Fair Deal |  |  | 25595 |  | 508 | 25392 | 33 | 33
Chevrolet | Silverado 1500 | 2019 | LT [NAME] | used | 1GCPWCED7KZ174446 | KZ174446A | 37800 | Fair Deal | 37434 | Fair Deal | 37393 | -366 | 662 | 37138 | 13 | 13
Dodge | Challenger | 2019 | SXT RWD | used | 2C3CDZAG5KH751602 | KH751602A | 29401 | Fair Deal | 28900 | Fair Deal | 29043 | -501 | 577 | 28824 | 39 | 39
Toyota | RAV4 | 2018 | XLE | used | [NAME] | JD133431A | 27499 | Fair Deal |  |  | 27175 |  | 883 | 26616 | 1 | 1
Toyota | 4Runner | 2020 | Venture 4WD | used | JTEBU5JR4L5835724 | L5835724A | 44900 | Fair Deal | 44532 | Fair Deal | 44446 | -368 | 716 | 44184 | 4 | 4
Ford | Expedition | 2016 | Limited | used | 1FMJU1KTXGEF50241 | [NAME] | 20293 | Fair Deal |  |  | 19812 |  | 747 | 19546 | 4 | 4
Toyota | RAV4 | 2019 | XLE AWD | cpo | 2T3P1RFV8KC017762 | PKC017762 | 31201 | Fair Deal |  |  | 30794 |  | 605 | 30596 | 61 | 61
Nissan | Frontier | 2019 | SV V6 Crew [NAME] | used | 1N6AD0ER8KN791266 | PKN791266 | 26220 | Fair Deal |  |  | 26173 |  | 677 | 25543 | 7 | 7
Volkswagen | Jetta | 2021 | 1.4T S FWD | used | 3VWN57BU7MM062835 | MM062835A | 25392 | Fair Deal | 25080 | Fair Deal | 24992 | -312 | 577 | 24815 | 10 | 10
Tesla | Model 3 | 2020 | Standard Plus RWD | used | 5YJ3E1EAXLF644813 | LF644813A | 50999 | Fair Deal | 50999 | Fair Deal | 50358 | 0 | 883 | 50116 | 13 | 13
Toyota | 4Runner | 2020 | SR5 4WD | cpo | [NAME] | PL5796218 | 38999 | Fair Deal |  |  | 38195 |  | 1097 | 37902 | 86 | 86
Mercedes-Benz | E-Class | 2019 | E 300 Sedan RWD | used | WDDZF4JB1KA578317 | PKA578317 | 41300 | Fair Deal |  |  | 40222 |  | 1420 | 39880 | 42 | 42
Toyota | 4Runner | 2020 | SR5 4WD | cpo | JTEBU5JR8L5796412 | PL5796412 | 38900 | Fair Deal |  |  | 37847 |  | 1346 | 37554 | 78 | 78
Ford | [NAME] | 2010 | STX | used | 1FTMF1CW5AKB57695 | PAKB57695 | 15900 | Fair Deal |  |  | 15004 |  | 1124 | 14776 | 6 | 6
Toyota | Highlander | 2019 | LE i4 FWD | used | 5TDZARFH8KS061375 | PKS061375 | 31190 | Fair Deal |  |  | 30383 |  | 1007 | 30183 | 33 | 33
Toyota | Tacoma | 2021 | SR5 V6 Double Cab RWD | cpo | [NAME] | MX106696A | 38366 | Fair Deal |  |  | 37701 |  | 1550 | 36816 | 12 | 12
Toyota | 4Runner | 2021 | SR5 4WD | cpo | JTEMU5JR8M5901766 | PM5901766 | 39999 | Fair Deal |  |  | 38659 |  | 1613 | 38386 | 37 | 127
Nissan | Rogue Sport | 2019 | S FWD | used | [NAME] | PKW528342 | 21887 | Fair Deal |  |  | 20731 |  | 1360 | 20527 | 33 | 33
Volkswagen | Jetta | 2020 | 1.4T S FWD | used | 3VWCB7BU6LM031199 | [NAME] | 22601 | Fair Deal |  |  | 21664 |  | 1099 | 21502 | 19 | 268
Volkswagen | Passat | 2021 | 2.0T SE FWD | used | 1VWSA7A30MC004834 | PMC004834 | 28219 | Fair Deal | 27783 | Fair Deal | 26996 | -436 | 1416 | 26803 | 19 | 19
Honda | Pilot | 2019 | EX-L FWD with Navigation and RES | used | 5FNYF5H43KB005056 | PKB005056 | 34900 | Fair Deal |  |  | 33611 |  | 1488 | 33412 | 44 | 93
Toyota | Tundra | 2020 | SR5 CrewMax 4WD | cpo | 5TFDY5F12LX926421 | PLX926421 | 44900 | Fair Deal |  |  | 42975 |  | 2198 | 42702 | 75 | 75
Acura | RDX | 2017 | FWD with Advance Package | used | 5J8TB3H7XHL015790 | HL015790A | 27499 | Fair Deal | 27443 | Fair Deal | 26497 | -56 | 1141 | 26358 | 5 | 5
Toyota | Tundra | 2020 | SR5 CrewMax 4WD | used | 5TFDY5F18LX918369 | LX918369A | 45622 | Fair Deal |  |  | 43632 |  | 2263 | 43359 | 36 | 36
Hyundai | Veloster | 2019 | Turbo FWD | used | KMHTH6AB3KU006861 | KU006861A | 24600 | Fair Deal |  |  | 23593 |  | 1144 | 23456 | 33 | 33
Toyota | Corolla | 2022 | LE FWD | new | 5YFEPMAE4NP346147 | NP346147 | 22877 | No Price Analysis |  |  |  |  |  |  | 55 | 55
Toyota | Corolla Hatchback | 2022 | SE FWD | new | JTND4MBE5N3186013 | N3186013 | 25118 | No Price Analysis |  |  |  |  |  |  | 24 | 24
Toyota | RAV4 | 2022 | LE FWD | new | 2T3H1RFV6NW219863 | NW219863 | 29103 | No Price Analysis |  |  |  |  |  |  | 2 | 2
Jeep | [NAME] | 2017 | Sport 4WD | used | 1C4BJWDG7HL535725 | PHL535725 | 32200 | No Price Analysis |  |  |  |  |  |  | 44 | 44
Toyota | Camry | 2023 | XLE FWD | new | 4T1F11AK6PU083610 | PU083610 | 33495 | No Price Analysis |  |  |  |  |  |  | 2 | 2
Toyota | Tacoma | 2022 |  | new | 3TYAX5GN9NT062892 | NT062892 | 34182 | No Price Analysis |  |  |  |  |  |  | 2 | 2
Toyota | Camry | 2023 | XSE FWD | new | 4T1K61AK3PU080308 | PU080308 | 34438 | No Price Analysis |  |  |  |  |  |  | 6 | 6
Toyota | Tacoma | 2022 |  | new | 3TYAX5GN7NT062664 | NT062664 | 34481 | No Price Analysis |  |  |  |  |  |  | 24 | 24
Subaru | Outback | 2021 | Limited Wagon AWD | used | 4S4BTANC0M3160078 | PM3160078 | 34900 | No Price Analysis |  |  |  |  |  |  | 87 | 87
Toyota | Tacoma | 2022 | SR V6 Double Cab 4WD | new | 3TMCZ5AN1NM523140 | NM523140 | 42633 | No Price Analysis |  |  |  |  |  |  | 2 | 2
Toyota | Tacoma | 2022 | [NAME] 4WD | new | 3TMCZ5AN3NM521258 | NM521258 | 42953 | No Price Analysis |  |  |  |  |  |  | 24 | 24
Toyota | Tacoma | 2022 | [NAME] 4WD | new | 3TMCZ5AN6NM502008 | NM502008 | 43505 | No Price Analysis |  |  |  |  |  |  | 67 | 67
Toyota | Tacoma | 2022 | SR V6 Double Cab 4WD | new | 3TMCZ5AN8NM513429 | NM513429 | 43908 | No Price Analysis |  |  |  |  |  |  | 2 | 2
Toyota | Highlander | 2022 | XSE FWD | new | 5TDLZRAH1NS133849 | NS133849 | 44838 | No Price Analysis |  |  |  |  |  |  | 2 | 2
Toyota | Highlander | 2022 | XSE FWD | new | 5TDLZRAH7NS130874 | NS130874 | 46578 | No Price Analysis |  |  |  |  |  |  | 24 | 24
Toyota | Highlander | 2022 | Limited FWD | new | 5TDYZRAH5NS555905 | NS555905 | 50329 | No Price Analysis |  |  |  |  |  |  | 2 | 2
Toyota | Highlander | 2022 | Limited FWD | new | 5TDYZRAH5NS555323 | NS555323 | 50488 | No Price Analysis |  |  |  |  |  |  | 24 | 24
Toyota | Highlander | 2022 | Platinum FWD | new | 5TDFZRAH9NS132106 | NS132106 | 51575 | No Price Analysis |  |  |  |  |  |  | 24 | 24
Chevrolet | Silverado 1500 | 2020 | LT Trail Boss Crew Cab 4WD | used | 1GCPYFELXLZ348434 | LZ348434A | 51999 | No Price Analysis |  |  |  |  |  |  | 21 | 21
Toyota | Tundra | 2022 | [NAME] | new | 5TFLA5DB6NX050337 | NX050337 | 55640 | No Price Analysis |  |  |  |  |  |  | 2 | 2
Toyota | Tundra | 2022 | Limited HV [NAME] | new | 5TFJC5DBXNX009467 | DNX009467 | 65804 | No Price Analysis |  |  |  |  |  |  | 5 | 7
Toyota | Tundra | 2022 | [NAME] [NAME] | new | 5TFPC5DB1NX004443 | NX004443 | 70855 | No Price Analysis |  |  |  |  |  |  | 9 | 9
Toyota | Tacoma | 2020 |  | cpo | 5TFAX5GN8LX182248 | LX182248A | 33900 | High Price | 33494 | Fair Deal | 30647 | -406 | 370 | 33530 | 11 | 11
Toyota | Tundra | 2020 | SR5 CrewMax RWD | used | 5TFEY5F11LX257966 | LX257966A | 40999 | High Price | 40512 | High Price | 38493 | -487 | 596 | 40403 | 4 | 4
Toyota | Tacoma | 2020 | [NAME] 4WD | cpo | 5TFCZ5AN1LX226134 | PLX226134 | 42553 | High Price |  |  | 38721 |  | 1835 | 40718 | 55 | 55