Another update:

Whilst searching for a possible answer it seems Excel (2003?) has a character limit on the CHOOSE part of the formula.

Is there a workaround formula for this?

Many thanks.