Identifying data within data

[magangonz]

I have a row of codes that begin with a letter and end in a number, e.g., M250, M300, X540. The letter that the code begins with indicates a borrough, e.g. M=Manhattan. I need to add a column next to the codes that identifies which city it matches with.

I have attached a sample of the data here to illustrate what I need to find.
(In my actual data set I have 2000+ rows which is why I need to find a formula to identify this)

[royUK]

You will need a list of Borough then combine Left with VLOOKUP.

Assuming the list is on Sheet 2,

=VLOOKUP(LEFT(B3,1),Sheet2!A1:B12,2,0)

[masteff]

You're looking for LEFT() and VLOOKUP(). See attached.