I have a table with more than 50 columns coming out of Adobe Report Builder. The data goes back two years and includes values for Paid Search, Natural Search, Email etc.
The date goes back to daily to 2019.
How would I go about getting for example Paid Search value based on a particular date.
Also, if for example I want to get the value between two dates (last week 2020 vs last week 2019 -- I have captured the weekly dates in other cells) how would I go about it?
I tried INDEX/MATCH unsuccessfully.
Basically I want to capture the value based on date and one of the marketing channels mentioned above. The red outline in the attached image is what I would like to fill based on the criteria for date and channel.
Any ideas?
The date goes back to daily to 2019.
How would I go about getting for example Paid Search value based on a particular date.
Also, if for example I want to get the value between two dates (last week 2020 vs last week 2019 -- I have captured the weekly dates in other cells) how would I go about it?
I tried INDEX/MATCH unsuccessfully.
Basically I want to capture the value based on date and one of the marketing channels mentioned above. The red outline in the attached image is what I would like to fill based on the criteria for date and channel.
Any ideas?