Formula to extract data if found in another cel

[Closed]
Report
Posts
2
Registration date
Tuesday March 24, 2015
Status
Member
Last seen
March 26, 2015
-
Hello,

I have a large excel spreadsheet and need a formula that can extract data from one cell if that same data is found in another cell. So, for example:
Color Fabric ID
Navy Navy Front to Back Tank
Optic White Optic White Birdseye Blouse

I want to remove the color from the Fabric ID column. So, if the color used in Fabric ID column is found in the color column, it needs to be removed from Fabric ID column.

Please let me know if you have any suggestions. Thank you!