Multiple lookupvalue problem

[Contirr24]

Good morning

I am struggeling to come up a solution for a problem i am having which I believe will involve using lookupvalue multiple times and in different ways.

I have two tables. 
Code table: This is a is a table with 1 column. Each row contains a unique code number.

Daily table:  This table has many columns. However, there are three columns which are important here
   -PrimaryCode
   -SecondaryCode
   -OtherCodes

I am looking to accomplish the below:
1. Add a new column to my daily table (Matched Code column)
2. In this column, i need to indicate all the instances of when the PrimaryCode,SecondaryCode or Other Code match a code found in the code table.  Additionally, the Other Code column can also have up to 20 different codes in this column seperated by commas. Below is briefly what i am trying to accomplish:

Code table:
Column1(CodeColumn)
11111
22222
33333
44444

Daily Table
PrimaryCode          SecondaryCode       Other Codes
11111                           64369                            91653,  22222, 16370
81626                           11111                             17350, 22222, 33333

What solution should look like:

Matched Code Column         PrimaryCode            SecondaryCode       OtherCodes                     
   11111 ,22222                           11111                           64369                             91653,  22222, 16370
   11111,22222,33333            81626                          11111                             17350, 22222, 33333

Thanks you for any assistance with this problem!

Ricky

[v-yuta-msft]

@Contirr24 ,

"In this column, i need to indicate all the instances of when the PrimaryCode,SecondaryCode or Other Code match a code found in the code table.  Additionally, the Other Code column can also have up to 20 different codes in this column seperated by commas. Below is briefly what i am trying to accomplish"

<--- Could you please clarify more details about this logic?

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.