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.