Hi everyone - thanks for helping out.

I need to compare a range of cells in Column 'A' (SKU #'s) to specific cell in Column 'B' (Model #). All of the matches in Column 'A' that contain Column 'B' would need to be entered into the cell in Column 'C', with the exception of the Column 'A' cell for the row we are on.

I hope that makes sense. I've attached two screenshots of an excel sheet where I manually entered Column 'C' results. The "Before and After" if you will. I need a formula that I can run down Column 'C' for several thousand rows.

Any help would be greatly appreciated

Screen Shot 2015-08-21 at 3.52.09 PM.png

Screen Shot 2015-08-21 at 3.58.43 PM.png