Here is my formula:

=IF(A20,(IF(ISNA(VLOOKUP(A2,INDEX('RUNNING DATA
wkly'!$3:$3,1,MATCH($G$1,'RUNNING DATA wkly'!$1:$1,0)):INDEX('RUNNING DATA
wkly'!$6000:$6000,1,MATCH($G$1,'RUNNING DATA
wkly'!$1:$1,0)+2),3,0)),0,(VLOOKUP(A2,INDEX('RUNNI NG DATA
wkly'!$3:$3,1,MATCH($G$1,'RUNNING DATA wkly'!$1:$1,0)):INDEX('RUNNING DATA
wkly'!$6000:$6000,1,MATCH($G$1,'RUNNING DATA wkly'!$1:$1,0)+2),3,0)))),"")

and I need to (SUM) up my (VLOOKUP) results I am only picking up 1item out
of multiple items on a list.

Hi.

I have had this problem in the past as well
However I have managed to tackle it with the use of a pivot table.
You may want to create a Pivot table of the data which would allow you to
add up the values under one head. You can then use the vlookup to pick up the
figures from the Pivot table.

Hope this helps





"Johnny" wrote:

Here is my formula:

=IF(A20,(IF(ISNA(VLOOKUP(A2,INDEX('RUNNING DATA
wkly'!$3:$3,1,MATCH($G$1,'RUNNING DATA wkly'!$1:$1,0)):INDEX('RUNNING DATA
wkly'!$6000:$6000,1,MATCH($G$1,'RUNNING DATA
wkly'!$1:$1,0)+2),3,0)),0,(VLOOKUP(A2,INDEX('RUNNI NG DATA
wkly'!$3:$3,1,MATCH($G$1,'RUNNING DATA wkly'!$1:$1,0)):INDEX('RUNNING DATA
wkly'!$6000:$6000,1,MATCH($G$1,'RUNNING DATA wkly'!$1:$1,0)+2),3,0)))),"")

and I need to (SUM) up my (VLOOKUP) results I am only picking up 1item out
of multiple items on a list.

I've had this problem for ages, just tried the pivot table suggestion and it
works, billiant, thanks Avi

"Avi" wrote:

Hi.

I have had this problem in the past as well
However I have managed to tackle it with the use of a pivot table.
You may want to create a Pivot table of the data which would allow you to
add up the values under one head. You can then use the vlookup to pick up the
figures from the Pivot table.

Hope this helps





"Johnny" wrote:

Here is my formula:

=IF(A20,(IF(ISNA(VLOOKUP(A2,INDEX('RUNNING DATA
wkly'!$3:$3,1,MATCH($G$1,'RUNNING DATA wkly'!$1:$1,0)):INDEX('RUNNING DATA
wkly'!$6000:$6000,1,MATCH($G$1,'RUNNING DATA
wkly'!$1:$1,0)+2),3,0)),0,(VLOOKUP(A2,INDEX('RUNNI NG DATA
wkly'!$3:$3,1,MATCH($G$1,'RUNNING DATA wkly'!$1:$1,0)):INDEX('RUNNING DATA
wkly'!$6000:$6000,1,MATCH($G$1,'RUNNING DATA wkly'!$1:$1,0)+2),3,0)))),"")

and I need to (SUM) up my (VLOOKUP) results I am only picking up 1item out
of multiple items on a list.