hey,
i have been having the same issue with a spreadsheet of my own!
how did you solve this? vlookup? as im yet to get that to work?

http://www.excelforum.com/excel-prog...condition.html