An example, I have 20 categories, each category is label with a fruit. So if
i put in one cell category 5, and category 5 is associated with apple, the
cell with the formula should automatically be filled in with the word "apple".

Does this make sense?


"Duke Carey" wrote:

Go to Excel 2007 which allows many more levels

Or, explain what you want to do. It's usually better handled by VLOOKUP or
SUMPRODUCT or the like. Somebody here can guide you if you provide the
background info


"J" wrote:

Does someone know how to increase the levels of nesting that will be allowed
in excel? Currently it's 8 levels.