This is a bit past where my knowledge has been before, but what I have done
is create 24 different tables that correspond to 4 different Input Variables.

Variables a
1. Ratings (225,250,450,500,550)
2. Quantity (1,2,3,4)
3. Runtime (5 through 48)
4. Manufacturer (0,1)

I had to sort the tables by Ratings and Quantity first then sorted by
runtime. Each manufacturer has its own table as well.

What I have done then is sort those 24 down into 12 by using the
=if(a84=0,A98,C98)

My ultimate goal is once someone chooses the 4 options above it displays the
selected information in the correct box no matter what is chosen.