Vlookup could be the answer... I've done that a number of times.
Help me help you... spell out *exactly* what you're trying to do. I almost wrote more to answer your first question, but didn't want to write a book
Give all the details of what you're trying to accomplish and why.