The following formula looks for the last instance of an entry containg the letter "A" in a small range or return "NoData" (supplied by daddylonglegs of this site)

How can I adapt the formula to select the last entry in the range containing the letter "A" OR "vc" and if neither return "NoData"
Any help appreciated

Rgds Nigel

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