One to many lookup help

[Paul at GTS]

I have a task that I can’t figure out how to achieve.

I have 2 workbooks.
One contains a list of "Selected" customers in Col A
The other contains a "Dump" of all customers with all contact names and details. Again Col A contains names and subsequent Cols contact names and details.

What I would like to happen is Excel looks up the customer from the Selected workbook and then looks up and retrieves the applicable contact details fro the Dump workbook.

The number of contact per customer varies.

Any ideas ?

 

[Aladin Akyurek]

Have a look at the VLOOKUP function.