use VLOOKUP function. Check excel's help on how to use it.

Mangesh