Expand comma separated values in a single field

I have an Excel file which contains a list of different codes separated by a comma. I need to compare each code to another workbook which I will name lookup. If the code from the main excel sheet has the word "Current" in the Status field, I have to write several values from the original table and the lookup.

Any ideas as to how to approach? I was thinking of putting both excel files in a dataframe, expand the comma separated values and compare both dataframes. However, I am having a hard time expanding the data. Any ideas?