finding a value ??

[coltheplumb]

Hi all ok i am trying to think of a formula that will work this out , i have colums of letters that are P, M or D, i would like to put a formula next to each letter that will give that particular letter a value and place it next to each letter, so P is 6, M is 12, and D is 18. Any ideas .
Thanks for any help with this
Colin X

 

[Weaver]

=lookup(a2,{"d","m","p"},{18,12,6})

 

[T. Valko]

Hi all ok i am trying to think of a formula that will work this out , i have colums of letters that are P, M or D, i would like to put a formula next to each letter that will give that particular letter a value and place it next to each letter, so P is 6, M is 12, and D is 18. Any ideas .
Thanks for any help with this
Colin X

One way...

=IF(A2="P",6,IF(A2="M",12,IF(A2="D",18,"")))

 

[coltheplumb]

Well done guys once again you come up trumps.
Thanks for your help
Colin X

 

[T. Valko]

Well done guys once again you come up trumps.
Thanks for your help
Colin X

You're welcome. Thanks for the feedback!