Hello,

My message is mostly to ShaneDevenshire!

You seem to be very good with formula. I am not sure that I will be able to
well explain what I'm looking for...since my mother tongue is French...but I
will try. Maybe you can help me as well.

I am trying to create an ''IF'' formula:
I would like to assign a number value to letters.

Ex:
column A line 1 = A and ''A'' refers to 80 (in column B)
column A line 2 = B and ''B'' refers to 75 (in column B)
column A line 3 = C and ''C'' refers to 70 (in column B)
column A line 4 = D and ''D'' refers to 65 (in column B)

In B15, should I write an A or any of the above letters (B, C or D), I would
like to have the result in C15. The result should be 80, or 75, or 70 or 65
depending on which letter I wrote down.

My best try is: =SI(B15=A2;$B$2)

But this is not enough and no matter what I added to my formula, it doesn't
work. I am going crazy with this....until I saw some of your comments...can
you help? I have no idea on how to make it work.