I think we need to be told more about C and D data
A B C D E
Male 1983 3333 4444 Yes
Female 1985 7777 8888 No


So what do you want to do?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Angel82" wrote in message
...
I have allot of data, for example cell A is gender, cell B is year of birth
and cell C is respondentnumber, cell D is also respondent number and cell
E
is kids yes/no. Cell C and D are both respondentnumbers, but they are both
from different datasources, I need to connect the right data from both
sources to eachother. In the end I have to know for each respondent what
its
corresponding gender, year of birth and if they have kids.