Difficult one for me to create a catchy title. Basically I have 2 worksheets that look like this:

Sheet1:

Reference    Description

SAA1         E001, E003
SAA2         E005
SAA3         E001, E003, E005, E004
Sheet2:

Number       Xref

E001
E002
E003
E004
E005
What I would like to do is take the description column in sheet one and match each of the numbers with the Number column in sheet 2 and then populate the xref column with the appropriate Reference number. ie:


Sheet2 would look like this:

Number       Xref

E001         SAA1, SAA3
E002         
E003         SAA1, SAA3
E004         SAA3
E005         SAA2, SAA3
Not sure if that makes sense, but I hope you can help. Many thanks