Hey guys. First time here and would like any help if possible. I'm a bit stumped at work. Maybe because I haven't had my coffee...

In column A is a master list of billing codes used by all of our companies. In column B1:G1 are six different companies, that we own along, with their respective billing codes that they use. I need help with a function that will match the billing codes of the different companies to the master file.

i made a sample worksheet to help in what I need. Sample.xlsx