IF formula to create Eisenhower Matrix

[Grishma]

Hi everyone,

My knowledge of excel is minimal and looking to get some help here.

I’m creating a formula where I have the datasheet with three columns – description, important & urgent.
I want the data (description) to be populated automatically when I select yes/no from the important/urgent column.

I have attached an image that I was looking to do!

I'd greatly appreciate your help here.

 

[Grishma]

Sorry I meant to say Table!

 

[Grishma]

Who are you talking to? also what do you

And the other issue is since it's not a Table, it doesn't read when you change its status from Not to Yes or otherwise.

 

[Fluff]

None of the solutions offered use a table.
As you have now marked post#7 as the solution, is everything working?

 

[Grishma]

None of the solutions offered use a table.
As you have now marked post#7 as the solution, is everything working?

it was but like I mentioned it's not working if I change the site names to a different random name. Instead of Site 1, Site 2,... I used Grishma, Fluff, toadstool etc..

 

[Fluff]

If it doesn't work, then please do not mark it as a solution.
Have you tried the formula I suggested?

 

[Grishma]

If it doesn't work, then please do not mark it as a solution.
Have you tried the formula I suggested?

Yes, I have tried!
two errors;
1. the site name issue
2. would it read automatically when you change the status from yes to no? - as it doesn't in the current structure.,

 

[Fluff]

The site names are irrelevant & yes it does change when columns J or K are changed

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H	I	J	K
1			Urgent		Not Urgent
2									Description	Important	Urgent
3		Important		Tom		abc			abc	Yes	No
4				Mary		Peter			xyz	No	Yes
5						Site9			Tom	Yes	Yes
6						Site10			Sue	No	No
7						Site11			Harry	No	Yes
8									Peter	Yes	No
9									Mary	Yes	yes
10									Site9	Yes	No
11									Site10	Yes	No
12		Not Important		xyz		Sue			Site11	Yes	No
13				Harry
14
15
16
17
18
19
20
Lists

Cell Formulas
Range	Formula
D3:D10	D3	=IFERROR(INDEX($I$3:$I$1000,AGGREGATE(15,6,(ROW($I$3:$I$1000)-ROW($I$3)+1)/($J$3:$J$1000="Yes")/($K$3:$K$1000="Yes"),ROWS(D$3:D3))),"")
F3:F10	F3	=IFERROR(INDEX($I$3:$I$1000,AGGREGATE(15,6,(ROW($I$3:$I$1000)-ROW($I$3)+1)/($J$3:$J$1000="Yes")/($K$3:$K$1000="No"),ROWS(D$3:D3))),"")
D12:D19	D12	=IFERROR(INDEX($I$3:$I$1000,AGGREGATE(15,6,(ROW($I$3:$I$1000)-ROW($I$3)+1)/($J$3:$J$1000="No")/($K$3:$K$1000="Yes"),ROWS(D$3:D3))),"")
F12:F19	F12	=IFERROR(INDEX($I$3:$I$1000,AGGREGATE(15,6,(ROW($I$3:$I$1000)-ROW($I$3)+1)/($J$3:$J$1000="No")/($K$3:$K$1000="No"),ROWS(D$3:D3))),"")

 

[Grishma]

Thanks so much; it works!

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[Toadstool]

Thanks so much; it works!

I changed the approach where you can hide row 1 and column A but use the contained Yes/No answers. This avoids different formulae for each quadrant.

Grishma2.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1			Yes	Yes	Yes	Yes	Yes	Yes		No	No	No	No	No	No		Description	Important	Urgent
2			Urgent							Not Urgent							Site772	Yes	No
3	Yes	Important	Site5							Site772	Great						Site2	Yes	No
4	Yes		Site18							Site2	Site19						Dog	Yes	No
5	Yes		Purple							Dog	Site20						Cat	Yes	No
6	Yes									Cat							Site5	Yes	Yes
7	Yes									Site6							Site6	Yes	No
8	Yes									Site14							Site14	Yes	No
9	Yes									Site8							Site8	Yes	No
10	Yes									Site9							Site9	Yes	No
11	Yes									Site10							Site10	Yes	No
12	Yes									Site11							Site11	Yes	No
13	Yes									11 Main St							11 Main St	Yes	No
14	Yes									Site13							Site13	Yes	No
15	Yes									Site7							Site7	Yes	No
16	Yes									Site15							Site15	Yes	No
17	Yes									Site16							Site16	Yes	No
18																	Great	Yes	No
19	No	Not Important	221 Ash Rd							Site42							Site18	Yes	Yes
20	No		Site23							Site43							Site19	Yes	No
21	No		Site24														Site20	Yes	No
22	No		Site39														Purple	Yes	Yes
23	No		Site40														221 Ash Rd	No	Yes
24	No		Site41														Site23	No	Yes
25	No																Site24	No	Yes
26	No																Site39	No	Yes
27	No																Site40	No	Yes
28	No																Site41	No	Yes
29	No																Site42	No	No
30	No																Site43	No	No
31	No
32	No
33	No
Sheet1 (2)

Cell Formulas
Range	Formula
J19:O33,C19:H33,J3:O17,C3:H17	C3	=IFERROR(INDEX($Q$2:$Q$10013,AGGREGATE(15,6,ROW($Q$2:$Q$10013)-ROW($Q$1)/(($R$2:$R$10013=$A3)*($S$2:$S$10013=C$1)),((COUNTIF($C$1:C$1,C$1)-1)*15)+(COUNTIF($A$3:$A3,$A3)))),"")