At present I am using:-

=IF(L6=4502,4402,IF(L10=4502,4410,IF(L14=4502,4407 ,IF(L18=4502,4403,IF(L24=4502,4411,IF(L28=4502,441 3,IF(L32=4502,4400,IF(L34=4502,4408,IF(L38=4502,44 17,""))))))))).

I'm using Excel 2003 and it won't allow 9 nested functions. Is there another
way around it,to get the same result
--
Reynella