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")
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";...
SergeiBaklan Thank you again for the quick help and explanation.
MischaTaba , you are welcome