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 next to that sum. I did it once successfully, but now I get an #N/A error code when entered again to fit the new row. This is the error: =INDEX($R$8:$S$27,MATCH(E12,$R$8:$R$27,0),2) but the cell above is the same formula but says E11, not E12. Any Help would be excellent! (The error is in column F)
6 Replies
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.
