Pivot Table, LookUp, Conditional Formatting, Basic Function
Make
ACURA
ACURA
ACURA
MAZDA
SUBARU
SUBARU
SUBARU
TOYOTA
TOYOTA
TOYOTA
ACURA
MAZDA
TOYOTA
TOYOTA
MAZDA
TOYOTA
TOYOTA
MAZDA
TOYOTA
TOYOTA
TOYOTA
TOYOTA
TOYOTA
TOYOTA
TOYOTA
TOYOTA
Model
Vehicle Class
Engine Size(L)
ILX
COMPACT
TSX
COMPACT
TSX
COMPACT
MAZDA5 MINIVAN
LEGACY AWD
MID-SIZE
OUTBACK AWD
SUV - SMALL
TRIBECA AWD
SUV - SMALL
4RUNNER (Part-Time
SUV - STANDARD
4WD)
4RUNNER 4WD
SUV - STANDARD
TUNDRA PICKUP TRUCK - STANDARD
ILX
COMPACT
MAZDA5 MINIVAN
4RUNNER 4WD
SUV - STANDARD
4RUNNER 4WD
SUV -(Part-Time
STANDARD4WD)
MAZDA5 MINIVAN
4RUNNER 4WD
SUV - STANDARD
4RUNNER 4WD
SUV -(Part-Time
STANDARD4WD)
MAZDA5 MINIVAN
4RUNNER 4WD
SUV - STANDARD
4RUNNER 4WD
SUV -(Part-Time
STANDARD4WD)
4RUNNER 4WD
SUV - STANDARD
4RUNNER 4WD
SUV -(Part-Time
STANDARD4WD)
4Runner 4WD
SUV - STANDARD
4Runner 4WD
SUV(Part-Time
- STANDARD
4WD)
4Runner 4WD
SUV - STANDARD
4Runner 4WD
SUV(Part-Time
- STANDARD
4WD)
Cylinders-
-
Transmission
AS5
AS5
AS5
AS5
AS5
AS5
AS5
AS5
AS5
AS5
AS5
AS5
AS5
AS5
AS5
AS5
AS5
AS5
AS5
AS5
AS5
AS5
AS5
AS5
AS5
AS5
Fuel Type
Z
Z
Z
X
X
X
X
X
X
X
Z
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
Fuel Consumption City (L/100 km)
Fuel Consumption Hwy (L/100 km-
-
Fuel Consumption Comb (L/100 km)
Fuel Consumption Comb (mpg-
CO2 Emissions(g/km-
-
MDX 4WD fuel type Using VLOOKUP
Z
Vehicle class that corresponds with the highest CO2 emission
VAN - PASSENGER