SUM BY USING "INDEX" AND "MATCH"

[Muhammad Haris]

Sample file attached, SUM by using " INDEX" and "MATCH" Formula

 

[Hui]

Muhammad

Firstly, Welcome to the Chandoo.org Forums

E3: =SUMPRODUCT(('Lookup table'!$D$5:$D$37)*('Lookup table'!$C$5:$C$37=C3))
Copy down

or
E3: =SUM(('Lookup table'!$C$5:$C$37=C3)*('Lookup table'!$D$5:$D$37)) Ctrl+Shift+Enter
Copy down

 

[Muhammad Haris]

Thanks but my Question is still pending, i want to apply INDEX & MATCH to solve this query, is there any possibility?.

 

[Hui]

Match returns a single value being the position in the range of the value you are looking up

So you can't use match to return an array of values, which you require to do to add up multiple values

Why the question when there are other, simpler formulas that work?

 

[rahulshewale1]

hiii,

you can use below formula also

{=SUM(IF(C4='Lookup table'!$C$5:$C$37,'Lookup table'!$D$5:$D$37))}
ctrl+shift+enter

=SUMIF('Lookup table'!$C$5:$C$37,'output file'!C4,'Lookup table'!$D$5:$D$37)


Thanks
rahul shewale

 

[Muhammad Haris]

Many thanks to all