VLOOKUP problem

In an excel file attached I have a problem with VLookUP. In a worksheet AJE Dec 06 in Column A there is a list of Account codes ie 01-0103. I'd like a VLookup or maybe Match might be better, I'm not sure, where in Column B the matching Account Code in Worksheet COA is found and returned on the same row and In Column C the coresponding Description is returned. I have a VLookup in those 2 columns to test but I'm getting the #na and incorrect account numbers.

The standard formulas for B2 and C2 would be

=VLOOKUP(A2,COA!$A$2:$B$269,2,0)

and

=VLOOKUP(A2,COA!$A$2:$B$269,3,0)

copied down the columns.....

....but these will return #N/A in all cases because your account codes don't match. If you want to match 01-0130 in A2 with 01-130 in your other worksheet you could try removing the additional zero from the codes or try

=VLOOKUP(REPLACE(A2,4,1,""),COA!$A$2:$B$269,2,0)