Comparing adjacent cell if match is found

First off, I would like to thank everyone that takes the time to share their knowledge of Excel on this forum. I have learned a lot by reading and will continue to do so. However, I am stumped on this one. I have searched for a solution for the better part of the day today and have not found a viable solution. For all I know, I may be searching using incorrect keywords. I am hopeful that there is a simple formula or solution that I am simply overlooking.

I have a spreadsheet that I need to compare multiple columns but I am unable to get an INDEX-MATCH to work properly. I am able to get it to work on a condensed version of the spreadsheet, but when I put it into the complete spreadsheet, I begin getting REF errors.

I am going to try to attach a sample of how the data is laid out and the (hoped for) expected results. I have never done this, so if it does not attach then I will try again.

Many thanks in advance!

Bobby

Oh wow! Just like that, huh? Dude! Your too awesome! Thanks!! It worked just like I had envisioned it would!