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.
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.