Import data from one xls file to another based on criteria
 

Hello All,

I have a small problem.
I have 2 files, 1 file contains contestant data such as name, address,
city, discipline.

The second file has the same structure, what I now want to do is select
in the second file a name and discipline and then get all the other
information imported. In the contestant data file a name can appear more
then once but only once per discipline.

Can somebody help me with this ?

Tanks in advance,
Peter