Hi,

I discovered a while back that Excel will only let you nest up to 7 IF
statements. This makes no sense to me, and I can't even come up with a
reason as to why Microsoft would continue to support this limitation
with the processing power of computers today...but I digress.

My problem is that I have a worksheet with a drop down list that has
about 30 items in it. I'm trying to construct the sheet so that when
one of the items in the list is selected it will populate a few other
cells.

Basically, the list is a list of text items. When one of the text items
in the list is selected I would like it to populate a specific number
into a different cell based on that specific text item.

I can't figure out a way around the 7 nested IF statement limitation.
Any help would be greatly appreciated.


--
EleKtriKaz
------------------------------------------------------------------------
EleKtriKaz's Profile: http://www.excelforum.com/member.php...o&userid=33141
View this thread: http://www.excelforum.com/showthread...hreadid=529503