Select cell value based on multiple criteria

yakhtar

New Member
Joined
Mar 18, 2014
Messages
23
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? :)
 

Attachments

  • Capture.JPG
    Capture.JPG
    104.6 KB · Views: 16

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Watch MrExcel Video

Forum statistics

Threads
1,118,273
Messages
5,571,253
Members
412,374
Latest member
Nagelgal
Top