Cell should be blank in data validation

[Zubair]

Dear Experts,

Please change the formula, I want the cells B3:B5 should be blank while selecting "Most Profitable" in B2, similarly if B2 is other then "Most Profitable" B6 should be blank.

Excel help with CHATGPT 3.xlsx
	A	B	C	D	E	F	G	H
1	User selection				Number of Scenario	Number of Years	Business Model	Number of columns
2	View	Most Profitable			Scenario 1	Y1	DF	1
3	Number of Scenario	Scenario 3			Scenario 2	Y2	SF	2
4	Number of of Years	Y3			Scenario 3	Y3	CF	3
5	Business Model	DF			Scenario 4	Y4		4
6	Number of columns	10			Scenario 5	Y5		5
7					Scenario 6	Y6		6
8					Scenario 7	Y7		7
9					Scenario 8	Y8		8
10					Scenario 9	Y9		9
11					Scenario 10	Y10		10
12					Scenario 11	Y11		11
13					Scenario 12	Y12		12
14					Scenario 13	Y13		13
15					Scenario 14	Y14		14
16					Scenario 15	Y15		15
17					Scenario 16	Y16		16
18					Scenario 17	Y17		17
19					Scenario 18	Y18		18
20					Scenario 19	Y19		19
21					Scenario 20	Y20		20
22								21
23								22
24								23
25								24
26								25
27								26
28								27
29								28
30								29
31								30
32								31
33								32
34								33
35								34
36								35
37								36
38								37
39								38
40								39
41								40
Multiple condiation data valida

Cells with Data Validation
Cell	Allow	Criteria
B2	List	Scenario by years, Years by scenario, Most Profitable
B3	List	=IF($B$2="Most Profitable","",E2:E21)
B4	List	=IF($B$2="Most Profitable","",F2:F21)
B5	List	=IF($B$2="Most Profitable","",G2:G4)
B6	List	=IF($B$2="Most Profitable",H2:H41,"")

 

[Zubair]

I pressed marked as solution but its still showing open, any reason ?

 

[mumps]

You are very welcome.

I pressed marked as solution but its still showing open, any reason ?

I'm not sure why but maybe try again.