How Can I pull in multiple answers to a cell when my lookup has cammas in it?

[mypearl]

Greetings everyone, and thank you in advance for guidance and help resolving my challenging issue. Two things that I'm not knowing how to do. vlookup is only bringing back the first item. and secondly how to add results to the same cell. my goal is this.

On my second tab "vlookup results" cell C2 I want a collection of comments from my first tab "vlookup table array" separated by cammas.

My challenge is I don't know how to search in my target field with cammas in it. Nor do I know how to get multiple answers In the same cell.

VLOOKUP("*" & A2 & "*",Lookup_Table,2,FALSE) is working, but not how I need it to.

The numbers in vlookup table array are actual words, but because what I'm working on is classified I had to chage that part to plane numbers.



vlookup result

RMF Ctrl ID Comments AC-1 1 AC-1 AC-1 AC-1 AC-11 AC-1 AC-1 AC-1 AC-1 AC-1 AC-1 AC-11 AC-11 AC-11(1) IA-4 IA-4 IA-4 IA-4(4) IA-4 IA-4 IA-4 IA-4 IA-4 IA-4(4) AC-17 AC-17 AC-17 AC-17 AC-17 AC-17(2) AC-17(2) AC-17(3) AC-17(3) AC-17(3) IA-2 IA-2(2) AC-17(4) AC-17(4) AC-17(4) AC-17(4) AC-17(4) AC-17(4) MA-4 MA-4 MA-4 MA-4 MA-4 MA-4 MA-4(1) <tbody> </tbody>

<tbody>
</tbody>

vlookup table array

AC-11, AC-11(1) AC-16, AC-16(1), AC-16(5), MP-3 AC-16, IA-4, IA-4(4) AC-17, AC-17(2), IA-2, IA-2(2), AC-17(3) AC-17, AC-17(2), MA-4, MA-4(1), MA-4(6), AC-17(3), AC-17(4), AC-17(7) AC-17, AC-17(9), AU-6, AU-6(5), CM-8, CM-8(3), IR-4, IR-4(5), SI-4 AC-18, AC-18(1), AC-19, AC-18(4), AC-18(3) AC-2, AC-2(7) AC-2, AC-2(7), AC-3, AC-3(4), AC-6, AC-3(7) AC-2, PS-4, PS-5 AC-3, AC-3(3)(4), AC-6, CM-3, CM-3(1) AC-3, AC-3(4), AC-4, AC-4(14), AC-4(15) AC-3, AC-3(4), AC-4, AC-4(14), AC-4(15) AC-3, AC-3(6), SC-13, SC-28, SC-28(1) AC-4, AC-16, AU-3 AC-4, CA-3, CA-3(1), SC-7, CA-3(2), CA-3(4), CA-3(5) AC-4, CA-3, CA-3(1), SC-7, CA-3(2), CA-3(4), CA-3(5) AC-5, AC-6, AC-6(2) AC-7, AC-9, AC-9(1), AC-9(2), AC-10 AC-8 AT-2, AT-3, CM-9, CM-9(1), CP-3, IR-2 AT-2, AT-3, CM-9, CM-9(1), CP-3, IR-2 AT-3, AT-3(1) AU-10, AU-10(5), SC-13, SC-13(4) AU-11 AU-2, AU-2(3), CP-10 AU-2, AU-3, AU-8 AU-7 AU-9 AU-9, AU-9(2) CA-1, CA-2, CA-(2) CA-2, CA-2(2), CA-7, RA-5 CA-3 CA-3 CA-3 CA-8, RA-5, SI-2, SI-2(1), SI-2(2) CM-1, CM-3, CM-3(4) CM-1, CM-3, CM-3(4) CM-1, CM-3, CM-9 CM-2, CM-8, CP-9, CP-9(3) CM-2, CM-8, CP-9, CP-9(3) CM-2, CM-8, CP-9, CP-9(3) CM-2, CM-8, CP-9, CP-9(3) CM-4, CM-4(2) CM-4, CM-6, CM-6(4), SI-2 CM-5, CM-5(5) CM-5, CM-5(6) CM-5, SA-10, SI-7 CM-6 CM-6 CM-7, CM-7(3) CP-10, CP-10(2) CP-10, CP-10(3) CP-2 CP-2, CP-2(1), CP-2(5), CP-2(6) CP-2, CP-2(4), CP-7 CP-4, CP-4(1) CP-4, CP-4(1) CP-4, CP-4(1) CP-4, CP-4(1) CP-4, CP-4(4), SC-7, SC-7(18), SC-24, SI-6 CP-6, CP-7, CP-7(5) CP-6, CP-9(5), CP-9 CP-6, CP-9(5), CP-9 CP-9, CP-9(3) CP-9, CP-9(6) IA-2, IA-2(5) IA-2, IA-4, IA-4(2), IA-5, IA-5(1), IA-4(3), IA-5(3), IA-5(4), IA-5(5), IA-5(6), IA-5(7) IA-5, IA-5(2), SC-12, SC-12-(4), SC-12-(5) IR-2, IR-3, IR-4, IR-5, IR-6, IR-7, IR-7(2), IR-8 IR-2, IR-3, IR-4, IR-5, IR-6, IR-7, IR-7(2), IR-8 IR-2, IR-3, IR-4, IR-5, IR-6, IR-7, IR-7(2), IR-8 MA-2, MP-6, MP-6(5), MP-6(5) MA-5, MA-5(1), MA-5(2), MA-5(3) MA-5, MA-5(1), MA-5(2), MA-5(3) MA-5, MA-5(1), MA-5(2), MA-5(3) MA-6 MA-6 MP-1, MP-2, SI-12 MP-4 MP-6 PE-10 PE-11, PE-11(2), PE-11(1) PE-12, PE-12(1) PE-13, PE-13(1), PE-13(2) PE-13, PE-13(1), PE-13(2) PE-13, PE-13(4) PE-14, PE-14(1) PE-14, PE-14(1) PE-19, PE-19(1) PE-2, PE-2(2), PE-3, PE-3(3), PE-8 PE-2, PE-2(2), PE-3, PE-3(3), PE-8 PE-2, PE-2(3), PE-3, PE-7 PE-3, PE-3(6) PE-3, PE-7, PE-8 PE-5 PE-9, PE-9(2) PL-1, PL-2, PM-10 PL-2, PL-2(2) PL-2, PL-2(2) PL-2, PL-2(2) PL-2, PL-2(2) PL-4, PS-8 PS-1, PS-6, PS-6(2) PS-6, PS-6(1), PS-6(2) PS-7, SA-9 SA-2 SA-4, SA-4(3), SA-11, SA-11(1) SA-4, SA-4(6), SA-4(7) SA-4, SA-4(6), SC-12, SC-12(2), SC-12(3), SA-4(7) SA-6, SA-6(1) SA-8 SA-9, SA-9(1) SC-1 SC-12, SC-12(3) SC-13, SC-28, SC-28(1) SC-18, SC-18(1), SC-18(2), SC-18(3), SC-18(4), SC-18(5) SC-19 SC-3 SC-4 SC-7, SC-7(12), SI-4, SI-4(1) SC-7, SC-7(19), SC-15, SC-15(2) SC-8, SC-13 SC-8, SC-13, SC-13(2) SC-8, SC-13, SC-13(3) SC-8, SC-8(2), SC-16, SC-16(1), SC-23, SI-7, SI-7(1), SI-7(12) SC-8, SC-8(2), SC-16, SC-16(1), SC-23, SI-7, SI-7(1), SI-7(12) SI-3 SI-4, SI-4(10) #N/A <tbody> </tbody>

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 <tbody> </tbody>

<tbody>
</tbody>