Forum Discussion
index/match error when using it more than once on a spreadsheet
Can you please test if E12 and R21 are identical. Please enter in a cell:
=MATCH(E12,R21,0)If the result is N/A, then the entries are not identical. Possibly text once?!
dscheikey They are not the same. But they are both numbers, not text.
I share an empty Excel sheet with you. Now you should be able to upload a file as well. For an error analysis I have to look into the file.
Here is a https://docs.google.com/spreadsheets/d/1oPlHlCMkZS5UkcOARx-kBqIr4xlF1BDE/edit?usp=sharing&ouid=102590612613016927406&rtpof=true&sd=true since I cant upload anything-
It is not a number, it is not a text! It is a formula.
When calculating, the computer does not take it so exactly.
The result is internally 0.7000000000001 or 0.699999999999999. Since you want to have an exact result with MATCH() this does not work.
But with ROUND() you can solve this easily.
=ROUND((B12+C12)-D12,1)
Hopefully it is down below. It would not let me add the file