Help to create table based on drop down list selection

So I have a table of three different conditions and need to create a summary table to reflect the entries in column A and the allocation (columns B, C or D) which is dependent on the condition selected in K1.

For example if you select "Low" I want to be able to just have Product 1 and Product 3 appear, with their corresponding allocations although that part I reckon can be done with a simple VLOOKUP. The tricky part is getting the product in the table in the correct order with no gaps.

Many thanks in advance.

Dynamic table example.xlsx

Apologies for the second post as a few of you kindly answered my first one a few days ago but I created a bit of a hash of it as some bits were omitted and also I tried to translate what I was doing over two separate files and it didn't work.

So I have a summary table in a file called "Scheme Sheet" of three different conditions to reflect the entries in "Master sheet" in column A and the allocation (columns B, C or D) which is dependent on the condition selected in "scheme sheet". Last time I had left the cells in the table that is now in "Master sheet" with nothing other than blanks when I in fact I should have put zeros in, however, the summary table in "scheme sheet" needs to ignore the zeros. Does that make sense?

For example if you select "Low" I want to be able to just have Product 1 and Product 3 appear, with their corresponding allocations although that part I reckon can be done with a simple VLOOKUP. The tricky part is getting the product in the table in the correct order with no gaps.

Many thanks again

Scheme sheet.xlsx

Master sheet.xlsx

Is there a reason/purpose for using two separate workbooks - why can't the two sheets be in the same workbook.

You can modify the formulas that Windknife gave you in post #3 of your previous thread replacing <>"" with <>0
If you want the result to be in a separate workbook then cut cells J1:K10 from Sheet1 of the Dynamic table example workbook and paste them into a new workbook.
Note that you will have to produce a list for the data validation drop down in cell K1 in the new workbook.
The formulas in cells J4:K10 should automatically update.
Let us know if you have any questions.

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.

Please note that you should NOT have created a new thread for this - you should have continued in the original thrread. Please don't duplicate threads in future (and please read the forum rules). Thanks.

I have merged your two threads.