|Sounds exactly like what VLOOKUP is used for.|
Read the Excel Help files on VLOOKUP, or do a Google search on it.
VLOOKUP is a very powerful function so you should get familiar with it.
If you have any problem getting it to work, come on back with what you've tried and we'll see if we can help out.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.