Another option is to use index-match formulas. These are not as volatile as Vlookup, and don't require anything to be formatted in a particular manner or alphabetized.
Index match is a nested formula - consisting of an index formula which references a match lookup. Assuming that the reference table is at site A1-B5, and the table you want to create is at D1-E5 with a lookup source in row D, this is what the formula should look like in cell E1.
As a two-part formula, the way it works is as follows:
The index formula returns the entry for column B that the Match formula looks for
The match formula looks for a result in column A that matches the entry in d1, and returns the row number. the 0 denotes an exact match.