Hi All,

I have an excel spreadsheet with 3 tabs as follow;

Sheet1 has following info;

Name ID Score
egemen 1 5
egemen1 2 4

Sheet2
ID value
1 6
1 5
2 10

Sheet3 is the results I want
Name ID Score Value
Egemen 1 5 6
Egemen 1 5 5
Egemen1 2 4 10

-----------------------
Egemen is repeated once in sheet1 but it has 2 values in sheet2 and sheet3 should show Egemen as 2 times with the values from Sheet1 and 2 different value from sheet2.

Egemen1 is only repeated once on both sheets so in Sheet3 it should only be shown once...

There is about 50 to 75 entries in sheet1 and ID number is the same number in both Sheet1 and Sheet2.

Value is unique number.