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.

```
=index($B$1:$B$5,Match(D1,$a$1:$a$5,0))
```

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.