Indeed it can be done easily enough using a combination of Excel's IF, INDEX & MATCH functions, without the need for a macro. Using the functions provides somewhat greater flexibility than a macro as they can update the output automatically according to changes in the inputs.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]