Excelchallenged119
New Member
- Joined
- Nov 21, 2011
- Messages
- 8
I need some assistance. I have a formula already but I need to add for more columns to it and I keep getting the error message - "you've entered too many arguments for this funtion" Below is the original formula and what i need to add.
=IF(ISNUMBER(MATCH("x",K5:N5,0)),CONCATENATE(FY_11_Word,", ",(INDEX(QTRs_FY11,1,MATCH("x",K5:N5,0)))),IF(ISNUMBER(MATCH("x",O5:R5,1)),CONCATENATE(FY_12_word,", ",(INDEX(QTRs_FY12,1,MATCH("x",O5:R5,-1)))),IF(ISNUMBER(MATCH("x",S5:V5,1)),CONCATENATE(FY_13_Word,", ",(INDEX(QTRs_FY13,1,MATCH("x",S5:V5,-1)))),"TBD")))
I need to add 4 more columns for FY 14 and add it to this formula above. Everytime I try and do i keep getting the error message. Can you please help?
Thank you!
=IF(ISNUMBER(MATCH("x",K5:N5,0)),CONCATENATE(FY_11_Word,", ",(INDEX(QTRs_FY11,1,MATCH("x",K5:N5,0)))),IF(ISNUMBER(MATCH("x",O5:R5,1)),CONCATENATE(FY_12_word,", ",(INDEX(QTRs_FY12,1,MATCH("x",O5:R5,-1)))),IF(ISNUMBER(MATCH("x",S5:V5,1)),CONCATENATE(FY_13_Word,", ",(INDEX(QTRs_FY13,1,MATCH("x",S5:V5,-1)))),"TBD")))
I need to add 4 more columns for FY 14 and add it to this formula above. Everytime I try and do i keep getting the error message. Can you please help?
Thank you!