You need a VLookup with a TRUE to do this easily. See this link and it explains the whole process.

http://www.howtogeek.com/howto/14455...ut-a-database/