I'm trying to make a worksheet that calculates the scrabble value of some Welsh words. I found an excel spreadsheet solution for English scrabble which I've pasted below, but the problem I've got is that Welsh scrabble has double letters like ff that have a separate value to f...is there a way to make a formula take that into account?

Values for Welsh scrabble

a 1

b 3

c 4

ch 5

d 1

dd 1

e 1

f 2

ff 4

g 2

ng 10

h 4

i 1

j 10

l 2

ll 5

m 3

n 1

o 1

p 5

ph 10

r 1

rh 10

s 3

t 3

th 4

u 2

w 1

y 1

Thanks!

Earlier solution for English scrabble

------

Put this table in G1:H26

A 1

B 3

C 3

D 2

E 1

F 4

G 2

H 4

I 1

J 8

K 5

L 1

M 3

N 1

O 1

P 3

Q 10

R 1

S 1

T 1

U 1

V 4

W 4

X 8

Y 4

Z 10

Then....for a word in A1

This formula calculates its scrabble value

B1:

=SUMPRODUCT(LOOKUP(MID(A1,ROW($A$1:INDEX($A:$A,LEN(A1),1)),1),$G$1:$G$26,$H$1:$H$26))

Is that something you can work with?

***********

Regards,

Ron

XL2002, WinXP