One to Many lookup

[lemonap618]

Hello,
And thank you for all the help!
Quick question - on the attached I have a sales manager tab. I would like to bring in the customer and revenue data for each sales rep. this is located on the "Map" tab. What is the best way to dynamically bring in the customer and revenue data. Looking for a formula.
For example - Huleniova, Zuzana has 16 customers ( I would like each customer listed in the sales manager tab with the corresponding revenue). Thanks!

[AliGW]

Your thread title does not seem to match what you are actually asking. Before we proceed, please amend it to be more indicative of what you are trying to do. Thanks!

When you've done that, please add your expected results manually to the yellow section in your sample workbook.

EDIT: Forget the request about the thread title - I was misreading it (as one too many lookup). Just please add the results to the workbook as requested.

[AliGW]

Just need the updated workbook, please.

[kvsrinivasamurthy]

In D2 then copied across.

Please Login or Register  to view this content.

[Glenn Kennedy]

A similar approach:

=IFERROR(INDEX((Map!$B:$B,Map!$C:$C),AGGREGATE(15,6,ROW(Map!$A$2:$A$1000)/(Map!$A$2:$A$1000=$C2),INT((1+COLUMNS($D2:D2))/2)),,1+MOD((COLUMNS($D:D)-1),2)),"")