I have a query which I am unable to solve.

I have certain Codes in Sheet1 as below [TABLE="align: left, border: 1, cellpadding: 1, width: 600"]

A

[/td]B

[/td]C

[/td]1

[/td]CODES

[/td]FINAL OUTPUT

[/td]TOTAL

[/td]2

[/td]991121QR5, 991121XSX, 991234SSC, 991121SDF

[/td]3

[/td]991121QR5, 991121XSX, 991234SSC

[/td]4

[/td]991121QR5, 991121XSX, 991234SSC, 991121SDF

[/td]

[/TABLE]

Sheet2 is as follows- [TABLE="align: left, border: 1, cellpadding: 1, width: 400"]

A

[/td]B

[/td]1

[/td]CODES

[/td]VALUES

[/td]2

[/td]991121QR5

[/td]100100

[/td]3

[/td]991121XSX

[/td]888888

[/td]4

[/td]991234SSC

[/td]123456

[/td]5

[/td]991121SDF

[/td]121212

[/td]

[/TABLE]

**The Final Outcome in Sheet 1 should be as follows:-** [TABLE="align: left, border: 1, cellpadding: 1, width: 600"]

A

[/td]B

[/td]C

[/td]1

[/td]CODES

[/td]FINAL OUTPUT

[/td]TOTAL

[/td]2

[/td]991121QR5, 991121XSX, 991234SSC, 991121SDF

[/td]100100, 888888, 123456, 121212

[/td]1233656

[/td]3

[/td]991121QR5, 991121XSX, 991234SSC

[/td]100100, 888888, 123456

[/td]1112444

[/td]4

[/td]991121QR5, 991121XSX, 991234SSC, 991121SDF

[/td]100100, 888888, 123456, 121212

[/td]1233656

[/td]

[/TABLE]

How can I get the above OUTCOME using one single formula to vlookup each value from cell A2 after comma+space from Sheet1 with the table in Sheet2 and place the output in same format as in cell A2 of sheet 1 in cell B2 of Sheet 1. This should repeat till the last comma+space is there in the series. Also how to add up all the values of B2 in C2.