Nov 14 2023 02:13 AM
When I insert the IFNA formula, it automatically enters a "+" symbol which unables it to function correctly therefore it always comes up as an error. When I delete the "+" symbol, it still appears as an error, and won´t work. In consequence, a warning appears on my screen telling me to insert an "´" symbol before the IFNA formula, in order to get the function working correctly, I enter it and still doesn´t work.
Nov 14 2023 03:56 AM
Do you create the formula by starting it with
=IFNA(
For example:
=IFNA(MATCH(A1, D1:D100, 0), "No Match!")