Hi!

Invert your lookup table such that:

F
E
D
C
B
A

Then: (assuming there are no empty cells in the range D1:M1)

=SUMPRODUCT(MATCH(D1:M1,A1:A6,0))

Biff

"nospaminlich" <nospaminlich@discussions.microsoft.com> wrote in message
news:75AF4B07-53DF-4B82-8FC1-2CF712D66DD3@microsoft.com...
> I've got a range of grades in cols D:M e.g B,C,A,D,F,B,C,A,A,E
>
> and a lookup table named "Points"
> A 6
> B 5
> C 4
> D 3
> E 2
> F 1
>
> In Col N I'm trying to create a formula which adds the points for each
> grade
> in Cols D:M
>
> Using the example above the answer would be 42 but I'm stuck on how to
> create a formula to calculate it.
>
> Any help would be much appreciated
>
> Thanks a lot