I using lookup formula below to get result if column (C) has three digit array,what would be the lookup formula if column (C) have 10 digit array and to get result like in D11? Any help would be much appreciated,thank you.

=VLOOKUP(LEFT(C2,2),$A$2:$B15,2,FALSE)&","&VLOOKUP(MID(C2,4,2),$A$2:$B15,2,FALSE)&","&VLOOKUP(RIGHT(C2,2),$A$2:$B$15,2,FALSE)

Code:

```
[TABLE="width: 551"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]01[/TD]
[TD="align: right"]11[/TD]
[TD]01 02 03[/TD]
[TD]11,14,26[/TD]
[/TR]
[TR]
[TD]02[/TD]
[TD="align: right"]14[/TD]
[TD]01 02 04[/TD]
[TD]11,14,29[/TD]
[/TR]
[TR]
[TD]03[/TD]
[TD="align: right"]26[/TD]
[TD]01 05 09[/TD]
[TD]11,32,47[/TD]
[/TR]
[TR]
[TD]04[/TD]
[TD="align: right"]29[/TD]
[TD]01 06 13[/TD]
[TD]11,35,63[/TD]
[/TR]
[TR]
[TD]05[/TD]
[TD="align: right"]32[/TD]
[TD]02 05 08[/TD]
[TD]14,32,44[/TD]
[/TR]
[TR]
[TD]06[/TD]
[TD="align: right"]35[/TD]
[TD]03 06 14[/TD]
[TD]26,35,72[/TD]
[/TR]
[TR]
[TD]07[/TD]
[TD="align: right"]38[/TD]
[TD]05 09 11[/TD]
[TD]32,47,56[/TD]
[/TR]
[TR]
[TD]08[/TD]
[TD="align: right"]44[/TD]
[TD]06 09 14[/TD]
[TD]35,47,72[/TD]
[/TR]
[TR]
[TD]09[/TD]
[TD="align: right"]47[/TD]
[TD]07 08 12[/TD]
[TD]38,44,60[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD="align: right"]51[/TD]
[TD]03 05 10[/TD]
[TD]26,32,51[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD="align: right"]56[/TD]
[TD]01 02 03 04 05 06 07 08 09 10[/TD]
[TD]11 14 26 29 32 35 38 44 47 51[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD="align: right"]60[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD="align: right"]63[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD="align: right"]72[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
```