Things to notice with this example:
● The options available in the Model dropdown change based on the selection of the Make.
● The data shown for each vehicle is stored in hidden rows and referenced using Excel's standard vlookup() function. |
|
Close |
|
|
|
|
|
|
|
|
|
|
| Welcome to Bud's Used Cars! |
|
|
|
|
|
|
Check out our current inventory of quality pre-owned vehicles |
|
|
|
|
|
|
Make: |
|
|
|
|
|
|
|
|
|
Model: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Miles: |
|
|
|
|
Year: |
|
|
|
|
Asking Price: |
|
|
|
|
|
|
|
|
|
Ford |
GM |
Toyota |
Nissan |
|
Select a Model |
Select a Model |
Select a Model |
Select a Model |
|
B4000 4WD |
9-3 CONVERTIBLE |
4RUNNER 2WD |
350Z |
|
CROWN VICTORIA POLICE |
9-3 SPORT SEDAN |
4RUNNER 4WD |
350Z ROADSTER |
|
E150 CLUB WAGON |
9-5 SEDAN |
AVALON |
ALTIMA |
|
E150 ECONOLINE 2WD |
C15 SILVERADO HYBRID 2WD |
CAMRY |
ARMADA 2WD |
|
ESCAPE 4WD |
C1500 SILVERADO 2WD |
CAMRY SOLARA |
ARMADA 4WD |
|
ESCAPE FWD |
C1500 SUBURBAN 2WD |
CAMRY SOLARA CONVERTIBLE |
FRONTIER 2WD |
|
ESCAPE HYBRID 4WD |
C1500 TAHOE 2WD |
COROLLA |
FRONTIER V6-2WD |
|
ESCAPE HYBRID FWD |
C1500 YUKON 2WD |
COROLLA MATRIX |
FRONTIER V6-4WD |
|
EXPEDITION 2WD |
COBALT |
ES 330 |
FX35 AWD |
|
EXPLORER 2WD |
COLORADO 2WD |
GS 300 4WD |
FX35 RWD |
|
EXPLORER 4WD |
COLORADO 4WD |
GS 300/GS 430 |
FX45 AWD |
|
F150 FFV 2WD |
COLORADO CAB CHASSIS INC 2WD |
GX 470 |
G35 |
|
F150 FFV 4WD |
COLORADO CREW CAB 2WD |
HIGHLANDER 2WD |
M35 |
|
F150 PICKUP 2WD |
COLORADO CREW CAB 4WD |
HIGHLANDER 4WD |
M35X |
|
F150 PICKUP 4WD |
CORVETTE |
HIGHLANDER HYBRID 2WD |
M45 |
|
FIVE HUNDRED AWD |
CTS |
HIGHLANDER HYBRID 4WD |
MAXIMA |
|
FIVE HUNDRED FWD |
DTS |
IS 250 |
MURANO AWD |
|
FOCUS FWD |
ENVOY 2WD |
IS 250 AWD |
MURANO FWD |
|
FOCUS STATION WAG |
ENVOY XL 4WD |
IS 350 |
PATHFINDER 2WD |
|
FREESTAR WAGON FWD |
EQUINOX AWD |
LS 430 |
PATHFINDER 4WD |
|
FREESTYLE AWD |
EQUINOX FWD |
LX 470 |
Q45 |
|
FREESTYLE FWD |
ESCALADE 2WD |
PRIUS |
Q45 SPORT |
|
GRAND MARQUIS |
ESCALADE ESV AWD |
RAV4 2WD |
QUEST |
|
GT 2WD |
G15/25CHEV VAN 2WD CONV |
RAV4 4WD |
QX56 4WD |
|
LS |
G1500/2500 CHEVY EXPRESS 2WD |
RX 330 2WD |
SENTRA |
|
MARK LT |
G1500/2500 CHEVY VAN 2WD |
RX 330 4WD |
TITAN 2WD |
|
MILAN |
G6 |
RX 400H 4WD |
TITAN 4WD |
|
MONTEREY WAGON FWD |
G6 GT/GTP CONVERTIBLE |
SC 430 |
XTERRA 2WD |
|
MOUNTAINEER 4WD |
GRAND PRIX |
SCION TC |
XTERRA 4WD |
|
MUSTANG |
GTO |
SCION XA |
|
|
NAVIGATOR 2WD |
H3 4WD |
SCION XB |
|
|
RANGER PICKUP 2WD |
HHR FWD |
SEQUOIA 2WD |
|
|
RANGER PICKUP 4WD |
I-280 2WD EXT CAB |
SEQUOIA 4WD |
|
|
TAURUS |
IMPALA |
SIENNA 2WD |
|
|
TAURUS ETHANOL FFV |
K15 SILVERADO HYBRID 4WD |
SIENNA 4WD |
|
|
THUNDERBIRD |
K1500 AVALANCHE 4WD |
TOYOTA TACOMA 2WD |
|
|
TOWN CAR |
K1500 SILVERADO 4WD |
TOYOTA TACOMA 4WD |
|
|
ZEPHYR |
K1500 TAHOE 4WD |
TOYOTA TUNDRA 2WD |
|
|
|
LACROSSE/ALLURE |
TOYOTA TUNDRA 4WD |
|
|
|
LIMOUSINE |
|
|
|
|
MALIBU |
|
|
|
|
MONTANA SV6 AWD |
|
|
|
|
MONTE CARLO |
|
|
|
|
RENDEZVOUS AWD |
|
|
|
|
RENDEZVOUS FWD |
|
|
|
|
SOLSTICE |
|
|
|
|
SRX 2WD |
|
|
|
|
SRX AWD |
|
|
|
|
SSR PICKUP 2WD |
|
|
|
|
STS |
|
|
|
|
STS AWD |
|
|
|
|
TERRAZA FWD |
|
|
|
|
TRAILBLAZER 2WD |
|
|
|
|
TRAILBLAZER 4WD |
|
|
|
|
TRAILBLAZER AWD |
|
|
|
|
TRAILBLAZER EXT 4WD |
|
|
|
|
UPLANDER FWD |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
B4000 4WD |
20,000 |
2005 |
$4,500 |
|
CROWN VICTORIA POLICE |
|
2006 |
|
|
E150 CLUB WAGON |
|
2007 |
|
|
E150 ECONOLINE 2WD |
|
2008 |
|
|
ESCAPE 4WD |
|
2009 |
|
|
ESCAPE FWD |
|
2010 |
|
|
ESCAPE HYBRID 4WD |
|
2011 |
|
|
ESCAPE HYBRID FWD |
|
2012 |
|
|
EXPEDITION 2WD |
|
2005 |
|
|
EXPLORER 2WD |
|
2006 |
$3,500 |
|
EXPLORER 4WD |
|
2007 |
|
|
F150 FFV 2WD |
|
2008 |
|
|
F150 FFV 4WD |
|
2009 |
|
|
F150 PICKUP 2WD |
|
2010 |
|
|
F150 PICKUP 4WD |
|
2011 |
|
|
FIVE HUNDRED AWD |
|
2012 |
|
|
FIVE HUNDRED FWD |
|
2005 |
|
|
FOCUS FWD |
|
2006 |
$4,800 |
|
FOCUS STATION WAG |
|
2007 |
|
|
FREESTAR WAGON FWD |
|
2008 |
|
|
C15 SILVERADO HYBRID 2WD |
|
2008 |
|
|
C1500 SILVERADO 2WD |
|
2009 |
|
|
C1500 SUBURBAN 2WD |
|
2010 |
|
|
C1500 TAHOE 2WD |
|
2011 |
|
|
C1500 YUKON 2WD |
|
2012 |
|
|
COBALT |
|
2005 |
|
|
COLORADO 2WD |
|
2006 |
$3,500 |
|
COLORADO 4WD |
|
2007 |
|
|
COLORADO CAB CHASSIS INC 2WD |
|
2008 |
|
|
COLORADO CREW CAB 2WD |
|
2009 |
|
|
COLORADO CREW CAB 4WD |
|
2010 |
|
|
CORVETTE |
|
2011 |
|
|
CTS |
|
2012 |
|
|
DTS |
|
2005 |
|
|
ENVOY 2WD |
|
2006 |
$4,800 |
|
ENVOY XL 4WD |
|
2007 |
|
|
EQUINOX AWD |
|
2008 |
|
|
EQUINOX FWD |
20,000 |
2005 |
$4,500 |
|
ESCALADE 2WD |
|
2006 |
|
|
ESCALADE ESV AWD |
|
2007 |
|
|
G15/25CHEV VAN 2WD CONV |
|
2008 |
|
|
G1500/2500 CHEVY EXPRESS 2WD |
|
2009 |
|
|
G1500/2500 CHEVY VAN 2WD |
|
2010 |
|
|
4RUNNER 2WD |
|
2011 |
|
|
4RUNNER 4WD |
|
2012 |
|
|
AVALON |
|
2005 |
|
|
CAMRY |
|
2006 |
$3,500 |
|
CAMRY SOLARA |
|
2007 |
|
|
CAMRY SOLARA CONVERTIBLE |
|
2008 |
|
|
COROLLA |
|
2009 |
|
|
COROLLA MATRIX |
|
2010 |
|
|
ES 330 |
|
2011 |
|
|
GS 300 4WD |
|
2012 |
|
|
GS 300/GS 430 |
|
2005 |
|
|
GX 470 |
|
2006 |
$4,800 |
|
HIGHLANDER 2WD |
|
2007 |
|
|
HIGHLANDER 4WD |
|
2008 |
|
|
HIGHLANDER HYBRID 2WD |
|
2005 |
|
|
HIGHLANDER HYBRID 4WD |
|
2006 |
$3,500 |
|
IS 250 |
|
2007 |
|
|
IS 250 AWD |
|
2008 |
|
|
IS 350 |
|
2009 |
|
|
LS 430 |
|
2010 |
|
|
LX 470 |
|
2011 |
|
|
PRIUS |
10,000 |
2012 |
|
|
RAV4 2WD |
|
2005 |
|
|
RAV4 4WD |
|
2006 |
$4,800 |
|
RX 330 2WD |
|
2007 |
|
|
RX 330 4WD |
|
2008 |
|
|
RX 400H 4WD |
|
2005 |
|
|
350Z |
|
2006 |
$3,500 |
|
350Z ROADSTER |
|
2007 |
|
|
ALTIMA |
|
2008 |
|
|
FRONTIER 2WD |
|
2009 |
|
|
FRONTIER V6-2WD |
|
2010 |
|
|
FRONTIER V6-4WD |
|
2011 |
|
|
FX35 AWD |
|
2012 |
|
|
FX35 RWD |
|
2005 |
|
|
FX45 AWD |
|
2006 |
$4,800 |
|
G35 |
|
2007 |
|
|
M35 |
|
2008 |
|
|
M35X |
|
2005 |
|
|
M45 |
|
2006 |
$3,500 |
|
MAXIMA |
|
2007 |
|
|
MURANO AWD |
|
2008 |
|
|
MURANO FWD |
|
2009 |
|
|
PATHFINDER 2WD |
|
2010 |
|
|
PATHFINDER 4WD |
|
2011 |
|
|
Q45 |
|
2012 |
|
|
Q45 SPORT |
|
2005 |
|
|
QUEST |
|
2006 |
$4,800 |
|
QX56 4WD |
|
2007 |
|
|
SENTRA |
|
2008 |
|
|
TITAN 2WD |
|
2009 |
|
|
TITAN 4WD |
|
2010 |
|
|
|
|
|
|