| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookup a Vlookup | Excel Worksheet Functions | |||
| VLOOKUP Problem | Excel Discussion (Misc queries) | |||
| VLOOKUP Limitations | Excel Worksheet Functions | |||
| Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
| vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Linear Mode
