Forum Discussion
Solved
IFS formula gives #N/A error
Hello, I have a simple IFS formula in my sheet. Its job is to look for a certain value in a certain range, if found it should return a specified value. And it does it's job at the first logical te...
=IFS(COUNTIFS($H$3:$H$30,LEFT(B3,4)),$H$2,COUNTIFS($I$3:$I$18,LEFT(B3,4)),$I$2,TRUE,"no match")
Looks like this is the fix. Could you also explain how, so i wont be making the same mistake again.
The main point don't miss texts with numbers.
If you'd like to return number 5 use
=IFS(E118=0;5;...not
=IFS(E118=0;"5";...MischaTaba , you are welcome
SergeiBaklan Thank you again for the quick help and explanation.