I have a student data sheet which feeds into a tracking proforma (Example attached).
Part of the proforma checks the current scores and uses it to measure the progress the student has made along a scale: 1-, 1, 1+, 2-, 2, 2+, 3-, 3, 3+etc.
The formula
=IFERROR((MATCH(G2,$L$2:$L$22,0))-(MATCH(C2,$L$2:$L$22,0)),"")
does not seem to recognise certain cell values (1, 2, 3...) while it will happily recognise the 1-, 2+ type cells, so I am left with blank boxes in the progress column.
I feel this is something very obvious but can't spot it, any guidance much appreciated.
Bookmarks