match up descriptions

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

see attachment
Who is Participating?
ShumsDistinguished Expert - 2017Commented:
Hi Sue,

You mean like attached?
ssblueAuthor Commented:
Perfect!  Thanks!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.