How to pull data from a Task List into an Eisenhower Matrix

[rsisk]

Need help with a formula that will pull the data from a task list and place the task item into Column D or I for the appropriate quadrant of the Eisenhower Matrix? The task list will indicate which quadrant the task should be placed.

Task List

 

[hagia_sofia]

Do you mean something like this (to be inserted into D5 and then copied to I5, D22, I22 after adjusting references):

=FILTER('Task List'!$C$4:$C$11;('Task List'!$F$4:$F$11=Matrix!B4)*('Task List'!$C$4:$C$11<>""))

 

[rsisk]

Do you mean something like this (to be inserted into D5 and then copied to I5, D22, I22 after adjusting references):

=FILTER('Task List'!$C$4:$C$11;('Task List'!$F$4:$F$11=Matrix!B4)*('Task List'!$C$4:$C$11<>""))

Yes. Exactly

 

[rsisk]

Do you mean something like this (to be inserted into D5 and then copied to I5, D22, I22 after adjusting references):

=FILTER('Task List'!$C$4:$C$11;('Task List'!$F$4:$F$11=Matrix!B4)*('Task List'!$C$4:$C$11<>""))

That did it. Thank you so much for your help.