You will want to use the vlookup function in both destination cells.

Here is a tutorial on vlookup.

http://www.techonthenet.com/excel/formulas/vlookup.php

Alan