I have an Excel macro which doesn't seem to be performing properly. You have to choose a "txt" file in the first field and then the "csv" file in the second and click "GO". The macro will compare the names of various mobile phones in the first row of each file, and then insert prices from the "txt" file into the "csv" file when a match is found.
The prices for some phones are correctly processed, but not the prices for others. The names of the phones in each file should be exactly the same. There is no partial matching, only exact matching. On the other hand, discrepancies with spaces or capitalisation might be allowed. However, in this case I think the names exactly match, and yet the prices are not replaced for one of the phones.
The project is to investigate why, and to fix the problem.