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.
=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.