VLOOKUP help please

[coltheplumb]

Hi All ok I have 50 items, all code numbered 1 to 50, each item has a credit value varying from 3 to 9. Up to 8 of these code numbers are going to be entered into cell A1:H1 . Now what I am after is setting up a VLOOKUP so that as each code number is entered a running total is shown in cell J1.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
All help appreciated<o></o>
<o> </o>
Cheers<o></o>
<o> </o>
Colin X <o></o>

 

[Jon von der Heyden]

Hi Colin

You didn't specify where the values are, but hopefully you can follow this example:

Excel 2010
	A	B	C	D	E	F	G	H	I	J
1	2	4	6	5	14	19				30.32
2
3	ID	Credit
4	1	5.89
5	2	3.42
6	3	5.91
7	4	6.18
8	5	7.75
9	6	5.51
10	7	4.4
11	8	7.63
12	9	6.13
13	10	6.22
14	11	8.72
15	12	7.03
16	13	5.11
17	14	3.06
18	15	4.26
19	16	6.03
20	17	3.18
21	18	8.05
22	19	4.4
23	20	3.26
Sheet1

Cell Formulas
Range	Formula
J1	=SUMPRODUCT(SUMIF(A4:A23,A1:H1,B4:B23))

 

[coltheplumb]

Brilliant works great
Cheers

Colin X