Please identify my error

[Zubair]

Dear Experts,

I am applying the formula but its giving blank in cell D5:G5.

=IFERROR(IF(COLUMN(A1)-COLUMN(D1)+1=1,LEFT(INDEX($B$2:$B$11,MATCH($D$2,$A$2:$A$11,0)),2),IF(COLUMN(A1)-COLUMN(D1)+1=2,IF(AND($D$2>=5,$D$2<=10),RIGHT(INDEX($B$2:$B$11,MATCH($D$2,$A$2:$A$11,0)),2),""),"")),"")

What I need is in D5:G5 the Business Model based on selection of data validation in D2, in this case I am expecting DF in D6 and SF in E6 whereas F6:G6 blank, similarly if I select 10 in D2 I need CF & CO in D6 & E6, however 1 means DF in D6, 2 means DF D6, SF E6, 3 means DF, SF & CF in D6, E6 & F6, 4 means DF, SF, CF & CO in D6, E6 F6, G6.

 

[Zubair]

Dear Experts,

I am applying the formula but its giving blank in cell D5:G5.

=IFERROR(IF(COLUMN(A1)-COLUMN(D1)+1=1,LEFT(INDEX($B$2:$B$11,MATCH($D$2,$A$2:$A$11,0)),2),IF(COLUMN(A1)-COLUMN(D1)+1=2,IF(AND($D$2>=5,$D$2<=10),RIGHT(INDEX($B$2:$B$11,MATCH($D$2,$A$2:$A$11,0)),2),""),"")),"")

What I need is in D5:G5 the Business Model based on selection of data validation in D2, in this case I am expecting DF in D6 and SF in E6 whereas F6:G6 blank, similarly if I select 10 in D2 I need CF & CO in D6 & E6, however 1 means DF in D6, 2 means DF D6, SF E6, 3 means DF, SF & CF in D6, E6 & F6, 4 means DF, SF, CF & CO in D6, E6 F6, G6.
View attachment 122438

Got the corrected formula,
=IF(COLUMN()=COLUMN($D$1),LEFT(INDEX($B$2:$B$11,MATCH($D$2,$A$2:$A$11,0)),2),IF(COLUMN()=COLUMN($E$1),IF(AND($D$2>=5,$D$2<=10),RIGHT(INDEX($B$2:$B$11,MATCH($D$2,$A$2:$A$11,0)),2),""),""))