The function to do this is VLOOKUP()
Unfortunately VLOOKUP() wont return values from columns to the left of the value being looked up.
So add a new column C
in C1 enter = A1
and drag the formula down.
Column B will have the values to be searched and column C will have the matched data to be returned.
Your values to be searched are now in column D
In cell E1 enter this:
Drag the formula down alongside all the values to be matched in column D.
The $ signs keep the search range fixed.
After dragging the formula down it should look like this in Cell E9 =VLOOKUP(D9,$B$1:$C$22,2,FALSE)
The 2 in the formula means that the result is returned from the second column of the table.
FALSE is required to ensure an exact match.
More information can be found about VLOOKUP() in Excel help files.