Trouble using look-up tables (HELP NEEDED)

[Luker95]

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

[Pepe Le Mokko]

Hi
while pictures are nice to look at, sample files posted on the forum are much easier to work with