Hey there, first post!

I am having trouble using Index Match in my conditional formatting formula for multiple selections.

I have 3 sections to my workbook,

1) A master list of materials

2) A list of materials with primary and secondary UPC Codes (the material is repeated in the line below for the secondary UPC code)

3) A "load column", used for copying and pasting lines of scanned materials.

When I obtain a list of scanned materials, I would like to copy and paste this list into the load column, and have it automatically format my master list column to green whenever either A) the material name itself is pasted, and B) its corresponding UPC Code is pasted.

For A), I'm using Countif with no problems.

For B), I'm running into trouble with Index Match when the Second UPC code is entered in the load column, it will not format.

This is what I am currently using
Please Login or Register  to view this content.
Below I have attached a sample workbook
Sample Workbook for Excel Forum.xlsx

Please let me know if you have any questions for clarification.
Thank you!