|Read the Excel Help files (or Google) for the VLOOKUP function.|
That function should return the results your are looking for.
The pre tags should only go around your example data, not around the text of your question.
I have edited your post to fix the problem.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.