Check if a cell matches string and take value from the adjacent cell

Hi,

I have the following problem which consists of a couple of smaller problems.

Imagine you have two sheets in one document. First one contains names of 5 employees and contracts they belong to, for instance:

John Doe	Contract A
Johnny Depp	Contract A
Tina Turner	Contract B
Orlando Bloom	Contract C
Bill Nye the Science Guy	Contract B

Then in another sheet you a list of contracts and it's expiry dates. What I would like to get is:

1. For each row in Sheet1 to take the name of the contract in the column B;
2. match the whole string to a contract name in Sheet2 column A;
3. take the numeric value of the current row's cell in column B;
4. put that value in Sheet1 column C.

I hope my explanation is clear enough. How can I achieve something like that?

Okay, this looks like the right direction, thanks!