I need to match up descriptions with a material group number.
I have a list of Material Groups and they have a unique number.
I also have a list of Material that I need to match as close as possible with the Material Group and then assign a Material number.
Column A contains the list of Material that needs to be classified.
Column E contains the Material Group Descriptions
Column F contains the Material Group Number
I need to look at Column A and match as close as possible to Column E and the pick Column F and return it to column B
I have inserted a few examples into column B