Index Modification

"Anthony Hoplite space space space..... "
will not match
"Anthony Hoplite"
to get rid of trailing spaces
select sheet 1 column v
then data/text to columns/fixed width/finish
that will give the result of 81.83
alternatively
try
=INDEX(Sheet1!$A$2:$AW$1520,MATCH($B5&"*",Sheet1!$V$2:$V$1520,0),MATCH($S$1,Sheet1!$A$1:$AW$1,0)
or
=INDEX(Sheet1!$A$2:$AW$1520,MATCH($B5,TRIM(Sheet1!$V$2:$V$1520),0),MATCH($S$1,Sheet1!$A$1:$AW$1,0) ) array entered with ctrl+shift+enter