I want to return the reference for the cell that starts with "Total".

Example rows (A1:A4):

Students
Lecturers
Tutors
Total

Using =MATCH("Total",A$1:A$10,0) returns 4, however in the real data, the value in A4 will be "Total XZY" depending on the contents, so I need to compare only on the first 5 characters of the cell.

Using =MATCH("Total",LEFT(A$1:A$10,5),0) returns #VALUE! error. When I go into the function editor window I can see that the formula is correctly being evaluated and resulting in 4, but it is not returning this. Image attached below.

Why is this happening and how can I achieve the desired result please?