Forum Discussion
Match with #N/A error
Hello, New here. In one column I have a drop-down menu with specific texts. The second column rates each text (e.g., MOR = 1. The third column has the texts written, one in each cell. My...
Galtin Hi and welcome.
I don't understand what you are trying to do.
As for the problem, the MATCH function has 3 arguments: lookup_value, lookup_array, and match_type
so in your formula the first MATCH has: MATCH(T5,R5:R14,...
So Excel will try to find the value in cell T5 in the range R5:R14
BUT then you have all the rest of that formula in the 3rd argument which is incorrect.
The 3rd argument can ONLY be -1, 0, or 1.
That 3rd argument indicates if the list is in order (small to large or large to small) and you should find the closest match or '0' meaning you only want an exact match and the list order doesn't matter. I can't imagine that your cascade of MATCH functions are spitting out -1, 0 and 1s and hence you have an error.