If you are using XL2003 or earlier, you are limited to 7 nested
functions in a formula. In the example you gave you will be within
this limit, but if you have more conditions you will quickly exceed
it, whereas the VLOOKUP approach does not suffer from this limitation.

Pete


On Jun 23, 12:04*pm, Nick C wrote:
Thanks Pete. Would still like to know how to do it using an IF formula, if it
is possible.

Regards,

Nick