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