Vlookup give only the first Value

[goldy2009]

Dear All,

I have an Inventory Workbook were Item codes in Left column and Date in top row. I am using the Vlookup formula Its displays only the first value.
If their are repeated dates for the same Item code I want to sumup the value according to the Date for that Item code.
Please find the attached sample file



I need to update the vlookup formula in the output, so that it takes the values accordingly and sumup.

I am not sure if I have explained this clearly; however, you will understand better if you see my attached file with examples of my expected output.

Appreciate for your quick reply

[AlKey]

Try this formula in B2 copy it down and to the right.

=SUMPRODUCT((Data!$A$2:$A$7=B$1)*(Data!$B$1:$AW$1=$A2)*(Data!$B$2:$AW$7))

	A	B	C	D	E	F	G	H	I
1	Item	8-Jul-14	9-Jul-14	10-Jul-14	11-Jul-14	12-Jul-14	13-Jul-14	14-Jul-14	15-Jul-14
2	c460-1	0	94	11	0	0	0	0	0
3	c460-2	0	1	0	0	0	0	0	0
4	c460-3	0	1	0	0	0	0	0	0
5	c460-3	0	1	0	0	0	0	0	0
6	EQ/PR/593	0	1	0	0	0	0	0	0
7	EQ/PR/590	0	1	0	0	0	0	0	0
8	EQ/PR/591	0	1	0	0	0	0	0	0
9	EQ/PR/592	0	1	0	0	0	0	0	0

[Richard Buttrey]

Hi,

I think you are misunderstand what a VLOOKUP function will give you. It will only return one value.

One way would be in B2 copied across and down

Please Login or Register  to view this content.