you can either use vlookup() or index() with match(). Please post a sample work book if you need any more help.