Combining Data from 2 sheets into one using formula's

[LearnerDriver]

Hi All,

I currently have 2 sheets both containing a single column that is common. What I am trying to achieve is a index and match on this column, effectively creating one master sheet.

Sheet 1

[TABLE="class: grid, width: 173"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD="colspan: 2"]WORKSHEET 01[/TD]
[/TR]
[TR]
[TD]VALUE W1-A[/TD]
[TD]VALUE W1-B[/TD]
[/TR]
[TR]
[TD]W1-A1[/TD]
[TD]W1-B1[/TD]
[/TR]
[TR]
[TD]W1-A2[/TD]
[TD]W1-B1[/TD]
[/TR]
[TR]
[TD]W1-A3[/TD]
[TD]W1-B1[/TD]
[/TR]
[TR]
[TD]W1-A4[/TD]
[TD]W1-B1[/TD]
[/TR]
[TR]
[TD]W1-A1[/TD]
[TD]W1-B2[/TD]
[/TR]
[TR]
[TD]W1-A2[/TD]
[TD]W1-B2[/TD]
[/TR]
[TR]
[TD]W1-A3[/TD]
[TD]W1-B2[/TD]
[/TR]
[TR]
[TD]W1-A4[/TD]
[TD]W1-B2[/TD]
[/TR]
[TR]
[TD]W1-A1[/TD]
[TD]W1-B3[/TD]
[/TR]
[TR]
[TD]W1-A2[/TD]
[TD]W1-B3[/TD]
[/TR]
[TR]
[TD]W1-A3[/TD]
[TD]W1-B3[/TD]
[/TR]
[TR]
[TD]W1-A4[/TD]
[TD]W1-B3[/TD]
[/TR]
</tbody>[/TABLE]

Sheet 2

[TABLE="class: grid, width: 173"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD="colspan: 2"]WORKSHEET 02[/TD]
[/TR]
[TR]
[TD]VALUE W2-B[/TD]
[TD]VALUE W2-C[/TD]
[/TR]
[TR]
[TD]W1-B1[/TD]
[TD]W2-C1[/TD]
[/TR]
[TR]
[TD]W1-B1[/TD]
[TD]W2-C2[/TD]
[/TR]
[TR]
[TD]W1-B2[/TD]
[TD]W2-C1[/TD]
[/TR]
[TR]
[TD]W1-B3[/TD]
[TD]W2-C1[/TD]
[/TR]
[TR]
[TD]W1-B4[/TD]
[TD]W2-C1[/TD]
[/TR]
[TR]
[TD]W1-B1[/TD]
[TD]W2-C3[/TD]
[/TR]
[TR]
[TD]W1-B5[/TD]
[TD]W2-C1[/TD]
[/TR]
[TR]
[TD]W1-B1[/TD]
[TD]W2-C4[/TD]
[/TR]
[TR]
[TD]W1-B6[/TD]
[TD]W2-C1[/TD]
[/TR]
[TR]
[TD]W1-B1[/TD]
[TD]W2-C5[/TD]
[/TR]
</tbody>[/TABLE]

Wanted Outcome

[TABLE="class: grid, width: 279"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD="colspan: 3"]WANTED OUTPUT TO WORKSHEET THREE[/TD]
[/TR]
[TR]
[TD]W1-A[/TD]
[TD]W2-C[/TD]
[TD]VALUE W1/W2-B[/TD]
[/TR]
[TR]
[TD]W1-A1[/TD]
[TD]W2-C1[/TD]
[TD]W1-B1 or W2-B1[/TD]
[/TR]
[TR]
[TD]W1-A2[/TD]
[TD]W2-C1[/TD]
[TD]W1-B1 or W2-B1[/TD]
[/TR]
[TR]
[TD]W1-A3[/TD]
[TD]W2-C1[/TD]
[TD]W1-B1 or W2-B1[/TD]
[/TR]
[TR]
[TD]W1-A4[/TD]
[TD]W2-C1[/TD]
[TD]W1-B1 or W2-B1[/TD]
[/TR]
[TR]
[TD]W1-A1[/TD]
[TD]W2-C2[/TD]
[TD]W1-B1 or W2-B1[/TD]
[/TR]
[TR]
[TD]W1-A2[/TD]
[TD]W2-C2[/TD]
[TD]W1-B1 or W2-B1[/TD]
[/TR]
[TR]
[TD]W1-A3[/TD]
[TD]W2-C2[/TD]
[TD]W1-B1 or W2-B1[/TD]
[/TR]
[TR]
[TD]W1-A4[/TD]
[TD]W2-C2[/TD]
[TD]W1-B1 or W2-B1[/TD]
[/TR]
[TR]
[TD]W1-A1[/TD]
[TD]W2-C3[/TD]
[TD]W1-B1 or W2-B1[/TD]
[/TR]
[TR]
[TD]W1-A2[/TD]
[TD]W2-C3[/TD]
[TD]W1-B1 or W2-B1[/TD]
[/TR]
[TR]
[TD]W1-A3[/TD]
[TD]W2-C3[/TD]
[TD]W1-B1 or W2-B1[/TD]
[/TR]
[TR]
[TD]W1-A4[/TD]
[TD]W2-C3[/TD]
[TD]W1-B1 or W2-B1[/TD]
[/TR]
[TR]
[TD]W1-A1[/TD]
[TD]W2-C4[/TD]
[TD]W1-B1 or W2-B1[/TD]
[/TR]
[TR]
[TD]W1-A2[/TD]
[TD]W2-C4[/TD]
[TD]W1-B1 or W2-B1[/TD]
[/TR]
[TR]
[TD]W1-A3[/TD]
[TD]W2-C4[/TD]
[TD]W1-B1 or W2-B1[/TD]
[/TR]
[TR]
[TD]W1-A4[/TD]
[TD]W2-C4[/TD]
[TD]W1-B1 or W2-B1[/TD]
[/TR]
[TR]
[TD]W1-A1[/TD]
[TD]W2-C5[/TD]
[TD]W1-B1 or W2-B1[/TD]
[/TR]
[TR]
[TD]W1-A2[/TD]
[TD]W2-C5[/TD]
[TD]W1-B1 or W2-B1[/TD]
[/TR]
[TR]
[TD]W1-A3[/TD]
[TD]W2-C5[/TD]
[TD]W1-B1 or W2-B1[/TD]
[/TR]
[TR]
[TD]W1-A4[/TD]
[TD]W2-C5[/TD]
[TD]W1-B1 or W2-B1[/TD]
[/TR]
[TR]
[TD]W1-A1[/TD]
[TD]W2-C1[/TD]
[TD]W2-B2 or W2-B2[/TD]
[/TR]
[TR]
[TD]W1-A2[/TD]
[TD]W2-C1[/TD]
[TD]W2-B2 or W2-B2[/TD]
[/TR]
[TR]
[TD]W1-A3[/TD]
[TD]W2-C1[/TD]
[TD]W2-B2 or W2-B2[/TD]
[/TR]
[TR]
[TD]W1-A4[/TD]
[TD]W2-C1[/TD]
[TD]W2-B2 or W2-B2[/TD]
[/TR]
</tbody>[/TABLE]


The closest thing I got was to use:
{=INDEX($B$3:$C$14, SMALL(IF(COUNTIF($E$3:$F$12,$C$3:$C$14), ROW($B$3:$C$14)-MIN(ROW($B$3:$C$14))+1), ROW(A1)), COLUMN(A1))}

This brings back the W1-A column correctly but not sure how to tie it up to bring back the W2-C values.

Any pointers or help would be appreciated

Cheers