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.