Index/Match issue

This formula locates on sheet 1. Since i'm trying to reference this number 123456167 to the second sheet with the format that looks like 0123456167, I'm trying to change value so both would be the same but I'm keep getting the #N/A.

=INDEX(Sheet2!$B$2:$C$399,MATCH((VALUE(A2)),VALUE(sheet2!$B$2:$B$33),2))

Could you tell me why the formula doesn't work?

TIA.