strikewind, Good evening.
You can use a VLOOKUP function to do this task.
If you want a more precise advise, please, save a short example of your excel file at a free site, www.speedyshare.com and put a link to download here.
Remember to put some data there and show the desired results.
Is it what you want?
I hope it helps.
Belo Horizonte, Brasil.