In match search how to display "NO DATA" if no instance of criteria

Hi I have adapted a formula to search a range for the last instance of an entry with the letter "A" prefix, it then displays it on a sheet relative to its item number. Took me a while because I hadn't noticed the item number I used first had no instance of an "A" and therefore was blank. How can I change formula to display "NO_DATA" when this occurs.

Any help appreciated

Rgds Nigel

=LOOKUP(REPT("Z",255),CHOOSE({1,2},"",LOOKUP(9.99E+307,MATCH(TRIM(LEFT(INDEX(total,MATCH($A$5,total1,0),0),2)),{"A","B","ac"},0),INDEX(total,MATCH($A$5,total1,0),0))))

* This formula was adapted from a version that initailly had to search for "A" or "VC" so I changed 3rd criteria to "ac" so it didn't record the "VC" entries