Extract a List of Values Filtered by Criteria with Sub-Arrays

Choosing Criteria and Output Data

We want to set our criteria as the minimum Combined MPG each car must have. For each vehicle that qualifies, we will want to list out the basic information about the model and its mileage. The criteria will be Column H, circled here in red. The output data will be Columns B through H, circled here in green.

Criteria Output