• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to use index and Match with Multiple sheets

Ajju1234

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

Attachments

  • Book15.xlsx
    12.1 KB · Views: 8
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
 
try
Code:
=SUMPRODUCT(SUMIFS(INDIRECT("'"&Sheet1!$U$2:$U$3&"'!"&"E$3:E$5"),INDIRECT("'"&Sheet1!$U$2:$U$3&"'!"&"d3:d5"),$D3))
 

Attachments

  • Book15.xlsx
    14.1 KB · Views: 6
Back
Top