How to populate list value to multiple range of cells have that list value on spreadsheet.

HI all,

I have very little advanced functions knowledge in Excel. Please help me out to find a solution for this.
Here’s the details on sheet1 and sheet 2:
On "sheet 1" I have a list of all the category person names from A4 to J6. I created a list for these category persons in column A1 without any duplicate. For this I defined the range “CategoryNames” which is in sheet 2.
What I really wanted to have is, When I select a name (Eg : Store Manager1) from the list, wherever the “Store Manager 1” is available in the range A4 to J6, those columns should be listed with the numbers that belongs to that specific "Store Manager 1" column. Other column which doesn’t have that selected name should not display anything down. This should happen for whatever the Person Name I select from the List box. Your help would be really appreciated.

I have attached the file for better understanding. Hope I explained well. Let me know if it’s not clear.

Thanks in advance.

Hi Dilip,

Thanks For the reply. Could you help me how to get the result like this.

I would like to populate the list box value to the Acct Manager row, that should trigger displaying that specific Acct Manager and the numbers listed under him.

If I choose Acct Manager 2 from the list, then row 4 should display Acct Manager 2 in B4 and in F4(those are the two cells having Acct Manager 2), then the values under those two columns should be displayed, other columns should be hidden or should not display any other acct managers and should not have any values under other acct managers.

Attached the files for more clarification.

I desperately needed this immediately. Your help would be really appreciated.
List box with multiple values.xlsx

Thanks
Chillu.