Combine two spreadsheets

Hi All,

I Think I've found a way by adding; =IF(COUNTIF(Sheet2!$A:$A,$A2)>=COLUMNS($D2:D2),INDEX(INDEX(Sheet2!$B$2:$B$6,MATCH($A2,Sheet2!$A$2:$A$6,0)):INDEX(Sheet2!$B$2:$B$6,MATCH($A2,Sheet2!$A$2:$A$6,0)+COUNTIF(Sheet2!$A:$A,$A2)-1),COLUMNS($D2:D2)),"")

Thanks for looking though.