Heshey,

On the first sight this seems a typical job for a VLOOKUP. But I must admit I don't grasp the full requirements.

There's info in Excel's help function, if the function wizard isn't clear enough. Or see http://www.ozgrid.com/Excel/excel-vlookup-formula.htm (just the first google hit for excel vlookup, you'll find many more if you go and look for it).

Hope this helps.


Kees