Introduce #N/F as a new ERROR.TYPE besides #/A
With the arrival of XLOOKUP() there is a real need for a new error.type that can distinguish a criteria not matched or not found from a non available value #N/A.
I suggest that a new #N/F i.e. a not found error be added and ERROR.TYPE(#N/F) would give ... 9, i.e. just after error.type 8 (#GETTING_DATA).
Besides ISNA() we could have also ISNF()
One must also think of what would return ISERR() and ISERROR() and what IFERROR() would do.
2
votes