I have an excel file that contains a column of Commodity Codes. On another sheet I have a list of valid Commodity codes. I need to create a table with a new column that indicates if the a commodity code in the Commodity Codes column is valid or not. The Commodity Codes columns can have multiple Codes serrated by a columns (see screenshot below) If any of the codes are valid the in the original column are valid, then the evaluation should indicate that the Commodity Code is valid.
I'm a little new to all this so I could use a little more hand holding. I have an excel file with 2 tabs. The first tab include many columns including Request ID as the identifier and Q8.2 Commodity Codes Selected containing the Commodity codes with some rows having multiple. I then have a second tab titled Valid Codes that contains a list of valid codes (Commodity Codes). How do I apply the logic above using the spreadsheet?