[Google Sheets] How to index/match multiple criteria across multiple sheets [data in same order]

theexcelcrowd

New Member
Joined
Jul 22, 2013
Messages
9
I have data from different campaigns in separate sheets [per market]. Actual data is five sheets but in the dummy data, I've only worked with two sheets. In a summary sheet, I want to be able to find the correct value for Sessions in column I of 'Email Sends' sheet. This should check for the month + market name [defined here as GA-1, GA-2] and then return the value based on the correct sheet. How can I accomplish this?
Thanks.
https://docs.google.com/spreadsheets/d/1o3Bwx7IHpgfi0xJdjbLx7wvC2AZhqdCOL4h-sKrLDYI/edit#gid=594963682
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
This should be in the questions forum.
If you haven't had an answer from elsewhere I think SUMPRODUCT array form is the way to go, with a dynamic range with the names of the sheets in.
 
Upvote 0
This should be in the questions forum.
I have moved it to this particular forum ("General Excel Discussion & Other Questions" forum) because it is a Google Sheets question (see thread title).
"Google Sheets" questions should be posted here, and not in the "Excel Questions" forum.
 
Upvote 0
Sorry Joe I didn't read the title :(
In which case my suggestion is probably worthless lol
 
Upvote 0

Forum statistics

Threads
1,213,489
Messages
6,113,954
Members
448,535
Latest member
alrossman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top