Matching and highlighting pairs

Hi everyone,

This is the first time I've posted in these forums, I'm an intermediate user of excel, but I cannot for the life of me figure out how to get my spreadsheet to function how I need it.

I work retail and we occasionally get shoes without pairs, or with a shoe of a different size. We call these mismates. I would like to get my sheet set up to automatically match up Pairs of shoes, and to highlight rows that match. The attached document shows a rough in of what the sheet would look like.

Basically I need the sheet to match both article number, and size, but match a left and right together. in the example row 2 and 5 are a mate, because the article and size match but are opposites feet.

Mismate.xlsxI'd love some help learning how to do this, I'm not just looking to have it done for me.



I appreciate any help!!



-Frank

The matching function works great, is there any way to highlight the entire row of the matching pair so that the helper column could be hidden?