As you've noticed, Excel only supports 7 nested IFs.

You can get around this by using a series of nested VLOOKUPS, based on
named ranges. The formula can get a bit cumbersome, so any example I
could give would be meaningless to you without your data.

Hope this helps.


--
BruceP
------------------------------------------------------------------------
BruceP's Profile: http://www.excelforum.com/member.php...o&userid=33653
View this thread: http://www.excelforum.com/showthread...hreadid=547908