SUM VLOOKUP

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Here is my formula:

=IF(A2>0,(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('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.
 
Hi.

I have had this problem in the past as well
However I have managed to tackle it with the use of a pivot table.
You may want to create a Pivot table of the data which would allow you to
add up the values under one head. You can then use the vlookup to pick up the
figures from the Pivot table.

Hope this helps
 
Back
Top