VLOOKUP MULTIPALS
 

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.

VLOOKUP MULTIPALS
 

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))

"Johnny" wrote:

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.

VLOOKUP MULTIPALS
 

thanks you very much

"Johnny" wrote:

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.

VLOOKUP MULTIPALS
 

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

"JMB" wrote:

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))

"Johnny" wrote:

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.

VLOOKUP MULTIPALS
 

You're welcome. Thanks for the feedback.

"Johnny" wrote:

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

"JMB" wrote:

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))

"Johnny" wrote:

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.