another
=SUMPRODUCT(--(ISNUMBER(MATCH(J2:J4,A2:F2,0))*K2:K4))

On Dec 12, 7:30*am, Don Guillett wrote:
One way
=SUMPRODUCT((OR(J2:J4=A2,J2:J4=B2,J2:J4=C2,J2:J4=D 2,J2:J4=E2,J2:J4=F2))*K2: K4)

On Dec 12, 1:48*am, "Mal" wrote:







I have a row of data (only six items).

A * *B * *C * *D * *E * *F
1 * * 3 * * 9 * *4 * * 2 * *8

A table of two columns
J * * * *K
1 * * * *3
2 * * * *2
3 * * * *1

=4 * * 0

I want to look up each of the values in A to F, assign a *value from column
K and Sum the results at G2

So values would be 3,1,0,0,2,0 and the Sum in G2 = 6

I have tried SUM(LOOKUP(A2:F2,J2:J4)) but end up with a #VALUE!

Any help appreciated.

Thanks,
Mal