Compare each value in a column in worksheet A to each value in a column in worksheet B

Pictures cannot be manipulated therefore, please upload your sample data so that we can provide you with a solution specific to your needs.

Not talking about code. Need to see your source data in a spreadsheet and not a picture. Attach a sample file. We cannot manipulate data in a picture.

Click on Attachments at the bottom of a new post in a thread. Between Smilies and Settings and above Reply.

Really, if you expect help, then you need to provide a realistic workbook. How do you expect anyone to determine a category for your accounts when all have the same description ("xxx"). You need to provide a realistic example. Account numbers or description. You also need to provide a look up table. Excel cannot think for you. It needs to make rationale decisions based upon information provided. At this point, you will need to research Vlookup as the function you need. Good Luck.