Multiple lookups returning value after string

I am currently, just using the RIGHT formula to return the last 4 characters from the cell, but where i run into problems is when the number at the end is double digits, it cuts off the text portion. So i found some other formulas, but they don't quite work yet so I thought of trying to combine these. I thought i could search for the text items, then once found return anything after that. The two new formulas are as follows:

Formula:

=RIGHT(A2,LEN(A2)-FIND(":",A2))

and

Formula:

=LOOKUP(9.999999999999999E+307,SEARCH(D$2:D$4,A2),D$2:D$4)

Maybe there is an easier way. Basically, what should happen is the following:

TEXT	EXPECTED RESULT	CURRENT RESULT	LOOKUP DATA
MCLBINDVARR1	AAR1	AAR1	ITR
MCLBINDVMaj1	Maj1	Maj1	MAJ
MCLBINDVMaj3	Maj3	Maj3	PMR
MCLBINDVMaj14	Maj14	aj14
MCLBINDVPMR1	PMR1
[blank cell]