Hello,
I'm a bit stumped here and any help would be much appreciated. I have a table populated by due dates corresponding to various columns with quality control names (i.e. Column A = Segmentation Due Date, A2 = 07/15/2020). I'm trying to create a summary sheet that indexes the table and then prints the column header for any cell where the date = Today. I have performed a similar function in the past to get a column value using the following formula but i'm getting tripped up this time because i'm looking across columns rather than down rows.
=IFERROR(INDEX(Email!C$2:$C$1000,SMALL(IF(Email!$F$2:$U$1000=$C$2,ROW(Email!$F$2:$F$1000)-ROW(Email!$F$2)+1),ROWS(Email!$F$2:Email!F3))),"")
Below is an image of the output i'm looking for. So columns A and B are indexing the column to capture the task ID and Campaign description and then i'd like to print the corresponding column header that dictates the required task. I'm sure there is a more elegant way to do this but i can't quite get there. Any help is much appreciated!
I'm a bit stumped here and any help would be much appreciated. I have a table populated by due dates corresponding to various columns with quality control names (i.e. Column A = Segmentation Due Date, A2 = 07/15/2020). I'm trying to create a summary sheet that indexes the table and then prints the column header for any cell where the date = Today. I have performed a similar function in the past to get a column value using the following formula but i'm getting tripped up this time because i'm looking across columns rather than down rows.
=IFERROR(INDEX(Email!C$2:$C$1000,SMALL(IF(Email!$F$2:$U$1000=$C$2,ROW(Email!$F$2:$F$1000)-ROW(Email!$F$2)+1),ROWS(Email!$F$2:Email!F3))),"")
Below is an image of the output i'm looking for. So columns A and B are indexing the column to capture the task ID and Campaign description and then i'd like to print the corresponding column header that dictates the required task. I'm sure there is a more elegant way to do this but i can't quite get there. Any help is much appreciated!