I don't think your current formula works because LEFT function is pulling the first two characters, that won't ever match with "A" unless the entry is "A" only. Try this version

=IFERROR(LOOKUP(2,1/(LEFT(INDEX(total,MATCH($A$5,total1,0),0))="A"),INDEX(total,MATCH($A$5,total1,0),0)),"NoData")