Forum Discussion

Copper Contributor

Jul 21, 2023

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

excel

Formulas and Functions

OliverScheurich
Jul 21, 2023
Vesperwind
=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.

OliverScheurich

Gold Contributor

Jul 21, 2023

Vesperwind

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

Vesperwind

Copper Contributor

Aug 06, 2023

Hey OliverScheurich! Sorry for the late reply!
I'd like to thank you because your formula works pretty well!!!
The only very last problem I have is when the F7 cell is empty: I get "#N/D" on B3.
Since when you open my file the starting point is you have 0 conditions applied, it would be visually good to have an empty cell instead of "#N/D".
Is there any solution to apply this in the formula? Otherwise I would go for conditional formatting...