VLOOKUP MULTIPALS

[Guest]

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.

 

[Guest]

Try:
=SUMPRODUCT(--(INDEX('Running Data wkly'!$3:$6000,0,MATCH($G$1,'Running Data
wkly'!1:1,0))=A5), INDEX('Running Data wkly'!$3:$6000,0,MATCH($G$1,'Running
Data wkly'!$1:$1,0)+2))

 

[Guest]

thanks you very much

 

[Guest]

Thank you very very much... you are a life saver. I hope that you have a
great Friday and a good weekend.

Thanks again!!!

Johnny

 

[Guest]

You're welcome. Thanks for the feedback.

Thank you very very much... you are a life saver. I hope that you have a
great Friday and a good weekend.

Thanks again!!!

Johnny