Adding categories to rows based on a master list

[regn]

Hello,

There is bunch of rows that I need to classify. Each row has a code value that belongs to a particular category. The codes are split into categories on another ark. There are however codes that are not included in any categories, and the list can be changed, for example, more codes and categories can be added. The example is attached. I don't really need to make a separate sheet with categories, they can be added to the existing sheet. Is VBA necessary here or it can be done some other way?

Thank you!

[vba_php]

Hello,

There is bunch of rows that I need to classify.

well you're welcome, but you didn't really ask a question, IMO. can you give any more detail?

[mazan2010]

Dear Regn
check attached file with two-way if i understand correct what exact you need
one with Index match formula

result will be in column G
and second with VBA code result will be in column H

[regn]

I have solved it manually without VBA. I copied column Code to a separate sheet, manually replaced all the values in correspondance with the master list, and then copied the edited column to the original sheet.
The thread can be closed.