Eisenhower Matrix on Excel

Hello Folks!

I'm trying to get a Eisenhower Matrix with following parameters: Urgency 1-4 and Importance 1-4.
I wan't to fill a table with tasks and add to each task mentioned parameters. This should be visualised in 16 boxes.

I got a formula with the paramters Urgency Yes or No and Importance Yes or No as following:
{=IFERROR(INDEX($B$2:$B$150,SMALL(IF((LEN($B$2:$B$150)<>0)*($L$2:$L$150="Yes")*($L$2:$M$150="No"),ROW($B$2:$B$150)-ROW($B$1),""),ROW(B2)-ROW($B$1))),"")}

So how can I transfer this forumla from the parameters Yes or No to the parameters 1-4? I tried to replace Yes with 1 and No with 2 but it didn't worked out...

Thanks for your help!!

Need your file to do this. Please see yellow banner at the top of the page.

By the way I have done this with a macro solution years ago for myself, although I just used 1-2. IMHO if you have 16 boxes you will be thrashing around.

Hello LorisNic and Welcome to Excel Forum.
Guessing that the data and the matrix should look something like that modeled on sheet1.
The formula used to fill the matrix is: =IFERROR(INDEX($A$2:$A$17,AGGREGATE(15,6,(ROW($A$2:$A$17)-ROW($A$1))/($B$2:$B$17=$F4)/($C$2:$C$17=G$3),COUNTIFS($F$4:$F4,$F4))),"")
Let us know if you have any questions.