'Why does my =MATCH formula give #N/A or the correct answer in the exact same circumstance?
I'm trying to find the column number using a =match formula. In particular I am looking for a result of 42. As you can see, the formula looking in row 16 finds the number 24 in the 42nd row, and gives this result. However, the formula looking in row 17 does not.
The data is all in number format, and I have done equal checks to ensure 24 does indeed equal the value in both AQ16 and AQ17. Finally, AQ16 and AQ17 are also equal.
Both arrays are also able to find all the data correct (i.e. produce an array which includes the number 24 in the 42nd entry). Despite this, the formula in row 17 does not find 24 in the array, even though it is present.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|