Campaign plan with two tabs - content view AND date view

Hello,

I have a spreadsheet that has a list of campaigns in column A and a list of marketing platforms in row 1 with dates plotted in the main body of the spreadsheet. I'd like the next tab to pull this information though but plot the dates along the top and display the marketing platforms in the centre - the list of campaigns in column A will stay the same for both tabs. The same date will be repeated multiple times in on the first tab, against different campaigns and marketing platforms. Is there a way to do this?

Hi
Can you please upload a sample of your spreadsheet, it will make understanding of the issue easier and assist greatly in devising a solution for you.

Cheers

Campaigns plan 2019.xlsx

Hi, thanks. Please find it attached here.

Please try at Sheet Data view B2 and copy over the table

=IFERROR(IF(OR(INDEX(INDEX('Content view'!$B:$T,MATCH($A2,'Content view'!$A:$A,),)=B$1,)),B$1,""),"")

Campaigns 2019 - test.xlsx

Hello AliGW, I've made a simpler version of the spreadsheet and filled in the information on the 'Date View' tab manually. I'm looking for a formula that can automatically input the information that's in the top cell of that column in the 'Content View' tab.

Thanks Bo_Ry - this formula is successful at automatically pulling though the date - once it's picked up the date, is there a way to then pull though the info in the cell at the top of the column?

Yes, the formula is successful at automatically pulling though the date - once it's picked up the date, is there a way to then pull though the info in the cell at the top of the column?

If you mean date for row 1 please try

B1 drag to the right

=IFERROR(AGGREGATE(15,6,'Content View'!$B$2:$E$4/('Content View'!$B$2:$E$4>MAX($A1:A1)),1),"")

B2 copy over the table

=IFERROR(INDEX('Content View'!$1:$1,AGGREGATE(15,6,COLUMN('Content View'!$A$1:$E$1)/(INDEX('Content View'!$A:$E,MATCH($A2,'Content View'!$A$1:$A$11,),)=B$1),1)),"")

That's worked. Thank you!

Campaigns plan 2019.xlsx

Bo_Ry, it's worked for the test spreadsheet I sent but I can't seem to get it to work for the main document - attached here. Also, I'm presuming this will mean I'm not able to have two dates on the same row of the 'Content view' tab?

Please see attached,

Formula for B3 is
=IFERROR(INDEX('Content view'!$A$1:$W$1,AGGREGATE(15,6,COLUMN('Content view'!$A$1:$W$1)/(INDEX('Content view'!$A:$W,MATCH($A3,'Content view'!$A$1:$A$107,),)=B$2),1)),"")

On the Content view, I add 3/1/2019 at C5 it show BMM magazine article on the data view.
But if you put same date on the same row it will show the first one on the left because AGGREGATE(15, will use the small number.

Great, thank you