Forum Discussion
Solved
Too many arguments error on IF/COUNTIF nested function: how to solve
Hi all, I need to write an excel formula with way too many nested functions, like the following one, but much longer: =IF(COUNTIF(F7;"*Example A*");"A";IF(COUNTIF(F7;"*Example B*");"B";IF(COUN...
=INDEX(J2:J23,MATCH(TRUE,ISNUMBER(SEARCH(I2:I23,F7)),0))An alternative could be this formula along with a reference table. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021. The formula is in cell B3.
You are welcome. Glad the formula works almost as intended.
=IFERROR(INDEX(J2:J23,MATCH(TRUE,ISNUMBER(SEARCH(I2:I23,F7)),0)),"")In order to return an empty cell B3 if F7 is empty you can try this formula. Actually i've only wrapped the formula into IFERROR. The formula has to be entered with ctrl+shift+enter if one doesn't work with Office 365 or Excel 2021.
That's what I needed!
Thank you SO much OliverScheurich!!!!