Hello,
My apologies if I'm using the wrong thread to ask for help, I'm not used to using this forum.
I'm having two separate issues, in the attached sheet, on the tab called 'campaign level' I have highlighted a box in yellow.
this yellow table references the table above, what I want it to do is to retrieve each of the individual columns in the above table and then provide a sum up for the clicks, impressions etc. for those individual assets.
so for example, if I change box k19 to say headline 2 from the drop down, I want it to pull all the values under the headline 2 header in the above table. and then in the clicks column I want it to sum-up the clicks and impressions from table 'raw data' which corresponds to that specific value from that specific header i.e headline 2.
So that leaves me with two problems. firstly I have used an Index/Match formula to pull down the values in the above table based on the criteria in the dropdown box k19, currently this retrieves all values including duplicates, is there away for me to make this only return one of each?
And secondly for summing up clicks and impressions etc. how do I get a sumifs formula to change the criteria column in 'raw data' based on the value in box K19?
Sorry if none of this makes sense. I've been playing with using the index/match formula all morning and just cant make it work
I massively appreciate any help that can be given! thank you!
Also, apologies for the incredibly random values, this is a work document I had to anonymize.
Bookmarks