Can I use the "IF" function to combine values in different cells?

Hi everyone. Here's my spreadsheet and what I'm trying to do:
oddppic.png
I want to make a formula for the cells in column B that will return the charge based on the "charge type" that I enter in column C. I'm not very savvy with excel, but I managed to put together the highlighted formula that works okay as long as there is only 1 charge type. Is there a way to modify the formula so it will combine the charges of multiple "charge types"? For example, I want the formula to return 28 in C4 and 29 in C6. Any help would be great!

Here's the actual workbook instead of just a picture of it: ODDP_Spreadsheet_test.xlsx

Originally Posted by :) Sixthsense :)

Refer the attached file for details

Thanks, your code does exactly what I wanted. I have no experience creating functions though so I have no idea what the parts of your code mean. Can you direct me to a tutorial or guide that would help me understand so I can recreate something similar if I need to?

Originally Posted by FDibbins

OK if you can split out the different rates, its easy. Use that same vlookup I suggested, wrapped in iferror() and copy it down and across...
=IFERROR(VLOOKUP(C2,$H$2:$I$7,2,FALSE),0)

Thanks for your formula too. I've never used vlookup before, and it sure helped a lot to simplify things. Is there any way I can use it to combine charges when multiples are used instead of displaying 0? Here's the spreadsheet with your formula:ODDP_Spreadsheet_test2.xlsx

Originally Posted by FDibbins

Can you answer that 1st?

Oh sorry. I don't think I'll have more than 5 charge types used at once. So a max of 5 combinations, if that's what you're referring too.

Originally Posted by ataulfo

Oh sorry. I don't think I'll have more than 5 charge types used at once. So a max of 5 combinations, if that's what you're referring too.

And actually 5 would be super unlikely. We could assume a max of 3 if that makes things easier.