Problem With Nested Formula

Greetings,

I am facing problem with nested formula. I want to locate salesman who is working against that customer

for example I have attached work book with two sheets . Second sheet is my master file where I want to know which salesman is working under which category

=SUBSTITUTE(SUBSTITUTE(MCONCAT(IF('Product Category'!$A$2:$A$5=E$2,'Product Category'!$B$2:$B$5,""),","),",",""),",","")

I have used this formula but unfortunately I am getting no result.

Please help me

look at the formulas

Greetings,

Its not working at all.. I need to lookup the Names of the salesman according to Brand Category provided in Sheet 1 and Master.

Example :- If Mahesh is taking care of A Brand Category , then all customers of A brand category should be listed against his name.. Please check Master file which might help..

Greetings,

I don't require Pivot Table .. Please refer my Master File

I need if Mahesh is taking care of A Brand Category then his name should occur in front of all customers those are having A Brand Category .

Please help!!!

Greetings,

Customer Name Brand Name Product Category Salesman Name

Blue Mars Supermarket ACORSA A Blank
Blue Mars Supermarket AEROPLANE B Blank
Blue Mars Supermarket AMERICAN GARDEN C Blank

Lets suppose these are some customers with brands and their product category.


If Mahesh is a salesperson going to Blue Mars Supermarket and he is taking care of Product Category - "A", then his name should occur in front of Blue Mars Supermarket only in front of "A" Product Category..

Example :-

Customer Name Brand Name Product Category Salesman Name

Blue Mars Supermarket ACORSA A Mahesh
Blue Mars Supermarket AEROPLANE B Dharmender
Blue Mars Supermarket AMERICAN GARDEN C Ambresh

is this closer to what you want?