I need to match related columns A and B to comparison columns D and E. A and D are assigned codes and will be compiled of random letter, numbers, and or symbols. Column D will sometimes contain multiple codes from column A with a space seperating the codes. Columns B is the amount connected to column A, and column E is connected to column D, as shown in the first line on my example D1 is a combination of A1 and A3 and E1 is the sum of B1 and B3. I would like to be able to identify all matches and highlight them. I currently work about 400 lines a day and would greatly appreciate some help in creating a macro to assist me.