Hi,
I have a pivot table with 4 columns of data: a concatenation of salesperson and account, Salesperson, Customer Name and Sales Amount.
Off to the side of the pivot table i have a lookup table that i am using for my dynamic chart that i want to show all the customer names and sales for just the particular salesperson selected. I've tried multiple formulas and I can't get it to pull back the 1st match. Instead it pulls back somewhere in the middle and then pulls back customer names that don't even fit the criteria. I thought this would be pretty simple.
I am attaching the workbook and you can see the other formula's i've tried in the text box and not one worked properly.
Bookmarks