populate values in col C based on values contains in B

Thanks for helping me so many days, I need ur help again...
I have 3 columns in my excel sheet,
Col A( Data)
Col B ( Invoice Description)
Col C( Result)

I have date and Invoice description column filled with data, I need to filter Column B> custom filter> contains > "Dup" and enter value as "Twice" in Column C.
again i customer filter> contains > " Canteen" then enter value in Column C as "Tea"
similarly i have 45 conditions and the number of rows are not fixed, I would appreciate very much if someone could help me to build a code with case function i can add all those conditions:

few Eg:
If values in Column B contains :"uncash" then in C column it should populate Credit in the respective rows
If values in Column B contains :"Dup" then in C column it should populate Twice in the respective rows
If values in Column B contains :"bug" then in C column it should populate Wow in the respective rows
If values in Column B contains :"RQ" then in C column it should populate Pay by Check in the respective rows
If values in Column B contains :"AP13" then in C column it should populate Payment in the respective rows
If values in Column B contains :"Canteen" then in C column it should populate Tea in the respective rows OF
If values in Column B contains :"RSV" then in C column it should populate Bus in the respective rows

A sample file is attached:

and also the cross post is here:
http://www.mrexcel.com/forum/showthr...41#post2153941

Thanks for you help
Arvind

Hi,

Thanks for your reply,

However vlookup is not working for this and not producing the right result
I have marked the result which is in correct and i have also mentioned the right result.

Thanks once again ..

Arvind