If formula - multiple conditions

Hi Guys,

This is probably a really basic formula to create, but I'm really struggling.

I need a formula that will do the following:

If Cell A1 = 1 then Cell B1 = 15
If Cell A1 = 2C then Cell B1 = 20
If Cell A1 = 2B then Cell B1 = 25
If Cell A1 = 2A then Cell B1 = 30
If Cell A1 = 3C then Cell B1 = 35

This would continue up until 6B.

I know that I need to use the if function, but I can't get past the first line! Is this relatively easy to solve?

Thanks in advance

John

Try: =LOOKUP(A1,{"A","B","C";15,20,25})
http://www.techonthenet.com/excel/formulas/lookup.php