VB Code to create DICT

Hello:

Please refer to attached file, sheet "Debit".
Based on what is in column C, i need to get values in column D as below:

If STREAM GEORGIA G BILL PAY 4001573008 then value in correcponsing cell in column D would be Utilities:Gas
If FOODSERVICE VENDOR PAY 072691182550000 then value in correcponsing cell in column D would be Cost of Goods:USFoods

etc

Bascially i would need to create VB Dictionary i guess, not sure.
Please help.


Let me know if you have any questions.
Thanks.

Riz

Hello xlaDept:

This works, however is there a way i can create a table 2 columns which replicate column C and D.
Then the code needs to lookup thru that table.
This was i can keep on adding more payee and catagory.
Please let me know if you have any questions.
Thanks.

Riz

Hello xlaDept:

Please refer to attached file.

I think there is some misunderstanding but we are nearly there.
Let me explain.
At the end of each month, i will be downloading lots of business account bank statement in excel.
So this is what i am trying to achieve.
It will be best if i have external table in Sheet1 of lets say at C:\Temp\CatTable.xls
Here the table will have 2 column of data, Column A wil be Payee and Column B will be the expense catagory.

My logic is to import the table at say Column H.
Now i will need to put Vlookup formula in column D to complete what i need.

Please let me know if you have any questions.
Thanks.

Riz

Hello bakerman:

Thanks a lot, will try for sure....iand i know it will work.
Riz