Getting same value with different options from drop-down list. For Google Sheets

[YaziR]

I'm currently working on a project where I need to create a drop-down list which should automatically populate the tables below. I'll straight away jump to the example for better understanding.
So the Sheet looks like this.
So the data is like

I think the table is self-explanatory. I have the data for each fruit that goes to which plate. So if I choose plate 5 from the dropdown list, I should get Apple, Orange, Pineapple, Mango and Berries in the table below.
Please help me with how to achieve this. Thank you in advance.

 

[Fluff]

Are the values in col A as you have shown, or are they like you have in A1 with the leading 0 on the number?

 

[YaziR]

Are the values in col A as you have shown, or are they like you have in A1 with the leading 0 on the number?

Hi. It can be without the leading 0 (Like Sector 1, Sector 2). The zero is not necessary though.
Thank you.

 

[Fluff]

It can be without the leading 0

Yes but what exactly are the values in col A, do they have the leading 0?
Also are you happy filtering the data to a different location?

 

[YaziR]

Yes but what exactly are the values in col A, do they have the leading 0?
Also are you happy filtering the data to a different location?

The data in column A is the sectors assigned for the person. As you see I have mentioned sector 4, and sector 8 for person 2. That means person 2 is working in sectors 2 and 8. And the data in column A doesn't have leading zero. So person 2 should reflect when I choose sector 4 and also when choose sector 8.
The problem I faced when filtering out to new location is, I can't edit the data. I used tried Query function and array formulas., in both cases, I was getting error when I try to edit data.

So basically, I should be able to do the following.
1. Select the sector from dropdown in A1 which auto populates the person working in sector 1 down the list.
2. Edit the target for each date.

Thank you.

 

[Fluff]

You didn't answer this question.

Also are you happy filtering the data to a different location?

 

[YaziR]

You didn't answer this question.

Yeah. Filtering to a new location is not a problem. But if I add the target in filtered data., the same should reflect on the main page. The purpose of the sheet is to enter and store the daily targets sector-wise.

 

[Fluff]

In that case you could use

=FILTER(A3:L19,isnumber(search(A1&",",A3:A19&",")))

 

[YaziR]

In that case you could use

=FILTER(A3:L19,isnumber(search(A1&",",A3:A19&",")))

Hai. Thank you for the formula. It does filter the data to a new location. But as I told you before. I couldn't add data to the filtered results. It gives me the following error.

Array result was not expanded because it would overwrite data

 

[Fluff]

No you cannot do that, but there was no mention of that in your op.

 

[YaziR]

No you cannot do that, but there was no mention of that in your op.

Hai I explained in this message that I need to edit the data.

The data in column A is the sectors assigned for the person. As you see I have mentioned sector 4, and sector 8 for person 2. That means person 2 is working in sectors 2 and 8. And the data in column A doesn't have leading zero. So person 2 should reflect when I choose sector 4 and also when choose sector 8.
The problem I faced when filtering out to new location is, I can't edit the data. I used tried Query function and array formulas., in both cases, I was getting error when I try to edit data.

So basically, I should be able to do the following.
1. Select the sector from dropdown in A1 which auto populates the person working in sector 1 down the list.
2. Edit the target for each date.

Thank you.

Is there any other workaround to do this?