I'm trying to create a table which uses a set of drop down menus and finds a appropriate values that are placed into a table, once in the table the quantitiy needs to be selected and data from another table needs to be found, I have attached a photo trying to explain my cause.

The drop down menus circled in Yellow when all options are selected determines the values that appear in the column circled in red.

Any ideas?

Thanks in advance.
Untitled.jpg