Answering a couple of variables to get the answer to an equation

Hey guys,

I'm trying to make a interactive Excelsheet, where the user is able to answer a couple of questions and is given a set result for that combination of answers.

The user answers the following questions with a list of variables:
-Client (7 options)
-Standard (depends on client, up to 20)
-(optional) substandard (depends on standard, up to 10)
-Material (50 materials)

The user also answers the following yes/no questions:
-coating
-glued
-cleanroom
-REIN1VOOR
-REIN1NA
-REIN2
-EXT
-IPA
-Oven
-Clean

As you can see this gives a long list of possibilites. Some of these questions affect one another in a certain way. Is it possible to make this, without creating a excelsheet with 700.000 rows?

The attachment shows how it would work in a simple manner. The first tab consists of the field of variables and the other tabs would 'carry' the possible combination of answers.

In what way would I be able to make a list of answers without manually answering the questions 700.000 times? Would that even be possible?

Hi,
I got your problem, but i need some more clear example, if is it possible to fill at-least 3 clients by manually to better understand?

I've changed the file to be a little more clear. An example is given of a combination of variables, which gives a certain answer to the equation.

Sorry didnt reply to you, see above