I need to use more than 7 formulas inside each other
 

Hello there.

I need to make a cell display different names depending on a number that is
typed on another cell. For example:

Cell B17 is editable and I want the user to type there numbers from 2 to 13,
depending on his own will.

Then, I want cell B18 to display a certain string that is dependable on the
choice made by the use on cell B17. I can do that up to 7 times (after that
Office XP gives an error message), but as you can see, I have 12 different
types of numbers to choose. How can I do it so I don't have to make the text
of the other 5 types be exhibited on a different cell?

Thanks!

I need to use more than 7 formulas inside each other
 

You can use VLOOKUP to look up values in a separate table, with no limit of 7
nested functions or else you can use XL 2007 which has a nesting limit of, I
think, 64 functions.

Info on VLOOKUP he http://www.techonthenet.com/excel/formulas/vlookup.php

Some other options on working around the 7 nested function limit he
http://www.ozgrid.com/Excel/nested-function-limit.htm

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"ghnogueira" wrote:

Hello there.

I need to make a cell display different names depending on a number that is
typed on another cell. For example:

Cell B17 is editable and I want the user to type there numbers from 2 to 13,
depending on his own will.

Then, I want cell B18 to display a certain string that is dependable on the
choice made by the use on cell B17. I can do that up to 7 times (after that
Office XP gives an error message), but as you can see, I have 12 different
types of numbers to choose. How can I do it so I don't have to make the text
of the other 5 types be exhibited on a different cell?

Thanks!

I need to use more than 7 formulas inside each other
 

LOOKUP or VLOOKUP?

=LOOKUP(B17,{2,3,4,5,6,7,8,9,10,11,12.13},{"text1" ,"text2",.........})

HTH

"ghnogueira" wrote:

Hello there.

I need to make a cell display different names depending on a number that is
typed on another cell. For example:

Cell B17 is editable and I want the user to type there numbers from 2 to 13,
depending on his own will.

Then, I want cell B18 to display a certain string that is dependable on the
choice made by the use on cell B17. I can do that up to 7 times (after that
Office XP gives an error message), but as you can see, I have 12 different
types of numbers to choose. How can I do it so I don't have to make the text
of the other 5 types be exhibited on a different cell?

Thanks!

I need to use more than 7 formulas inside each other
 

try
=choose(b17,"","Textfor2","textfor3",...,"text for 13")

"ghnogueira" wrote:

Hello there.

I need to make a cell display different names depending on a number that is
typed on another cell. For example:

Cell B17 is editable and I want the user to type there numbers from 2 to 13,
depending on his own will.

Then, I want cell B18 to display a certain string that is dependable on the
choice made by the use on cell B17. I can do that up to 7 times (after that
Office XP gives an error message), but as you can see, I have 12 different
types of numbers to choose. How can I do it so I don't have to make the text
of the other 5 types be exhibited on a different cell?

Thanks!

I need to use more than 7 formulas inside each other
 

Have a look at the lookup functions VLOOKUP and HLOOKUP
--
Bernard Liengme
http://people.stfx.ca/bliengme

"ghnogueira" wrote in message
...
Hello there.

I need to make a cell display different names depending on a number that
is
typed on another cell. For example:

Cell B17 is editable and I want the user to type there numbers from 2 to
13,
depending on his own will.

Then, I want cell B18 to display a certain string that is dependable on
the
choice made by the use on cell B17. I can do that up to 7 times (after
that
Office XP gives an error message), but as you can see, I have 12 different
types of numbers to choose. How can I do it so I don't have to make the
text
of the other 5 types be exhibited on a different cell?

Thanks!