Automatically filling in a column based on 2 first digits of another one

[bxlakke]

Hey,

I need your help.
Is there any formula to fill in a column based on the first 2 digits of another cell?
Column A : filled with codes made up from 2 digits & 3 letters ex. 02AAA or 07BBB
Column B ; should display a value based on the first 2 digits. ex. 02 = A2 / 07 = A41 / 03 = A5 etc
i have all these values in another sheet. Can anybody advice me?

A	B ( needs to be filled in automatically based on vlues of column A en B of another sheet
02AAA	A2
07BBB	A41
02CCC	A2
07DDD	A41
03EEE	A5

values
02	A2
03	A5
07	A41
etc	etc

 

[Fluff]

You can use Vlookup for that. How to use the Excel VLOOKUP function | Exceljet