How to use index and Match with Multiple sheets

[Ajju1234]

Can anyone tell me that how to use Index and Match function by Multiple sheets.
Examples is attached.

 

[ETAF]

are you trying to sum the sheets
you can use a 3d sumif or sumifs

can you give expected results
and also version of excel you are using

 

[herofox]

try

=SUMPRODUCT(SUMIFS(INDIRECT("'"&Sheet1!$U$2:$U$3&"'!"&"E$3:E$5"),INDIRECT("'"&Sheet1!$U$2:$U$3&"'!"&"d3:d5"),$D3))

 

[bosco_yip]

try

=SUMPRODUCT(SUMIFS(INDIRECT("'"&Sheet1!$U$2:$U$3&"'!"&"E$3:E$5"),INDIRECT("'"&Sheet1!$U$2:$U$3&"'!"&"d3:d5"),$D3))

A lot of way, why not just >>

In E3, enter formula then copied across right and down, and will obtain the same result :

=Sheet1!E3+Sheet2!E3

 

[Ajju1234]

try

=SUMPRODUCT(SUMIFS(INDIRECT("'"&Sheet1!$U$2:$U$3&"'!"&"E$3:E$5"),INDIRECT("'"&Sheet1!$U$2:$U$3&"'!"&"d3:d5"),$D3))

THANK YOU