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...
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.