Here is my formula:

=VLOOKUP(A5,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)

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