Hi, Eric -
I read your query, and it sounds as if VLookup may be of help to you. You may want to look in the Help directory of XL or do a search for VLookup on the Board. I have used it myself, and it works great. Plus, the users on this board are absolutely fantastic when it comes to asking and obtaining help.