Removing/editing text from an array for vlookup

[rossa]

Here is a simplified example, A2:B7 contain the following (A is just months in the format "mmm" with a leading "A").

AJan	34
AFeb	56
AMar	73
AApr	45
AMay	51
AJun	49

<colgroup><col style="width: 48pt;" span="2" width="64">
<tbody>


</tbody>

Column E contains these months in the "mmm" format. To convert any of the cells in column A the following formula can be used "MID(A2,2,LEN(A2)-1)".
Is there any way to applay this to the entire contents of Column A within a VLOOKUP?

Thanks