Forum Discussion
index/match error when using it more than once on a spreadsheet
I am using index/match to take an answer to a sum, then it finds that sum in a specific table (The one all the way to the right in the picture), and then I want it to return the value in the column n...
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)