Forum Discussion
Weird MATCH error
I am trying to connect data from one excel file to another, using INDEX and MATCH. The problem is with the MATCH function. When I try just the MATCH function, I get #N/A as if it can't find the value...
If text format was applied to the cell, you enter 123 into it, it will be text "123". If to apply number format to the cell it still will be text "123" in the cell. Applying of format doesn't convert text to number, you shall to re-enter the value. F2 -> Enter and now you have number value.
Text To Columns is most common way to re-enter values at once if the they are in one column. Step-by-step instruction is here How to Refresh Cell Data After Applying Number Formatting in Excel (groovypost.com)
Or you can use numbervalue function in your formula to change texts to numbers on the fly)
Artur
Artur
If only you don't use PivotTable or like for the analysis.