I need to use more than 7 formulas inside each other

[Guest]

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!

 

[Guest]

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 here: http://www.techonthenet.com/excel/formulas/vlookup.php

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

Dave

 

[Guest]

LOOKUP or VLOOKUP?

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

HTH

 

[Guest]

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

 

[Bernard Liengme]

Have a look at the lookup functions VLOOKUP and HLOOKUP

 

[Guest]

Thanks everyone for the help, but I didn't quite get how VLOOKUP will help me
here, since it returns a number, and I want a text.

My current function is something like this:

=IF(B17=2;"bone dry";IF(B17=3;"greasy";IF(B17=4;"moist";0)))

But I want that to go until B17=13, but max I can go is B17=9.

The thing I want written are the text tags "bone dry", "greasy", etc,
depending on the value of the cell B17.

How would VLOOKUP help me making that?

Thanks again!

 

[Guest]

vlookup will respond with text

Thanks everyone for the help, but I didn't quite get how VLOOKUP will help me
here, since it returns a number, and I want a text.

My current function is something like this:

=IF(B17=2;"bone dry";IF(B17=3;"greasy";IF(B17=4;"moist";0)))

But I want that to go until B17=13, but max I can go is B17=9.

The thing I want written are the text tags "bone dry", "greasy", etc,
depending on the value of the cell B17.

How would VLOOKUP help me making that?

Thanks again!

 

[Guest]

Yeah, just made it work. The link you provided was very helpful. I was kinda
lost on the other one!

Many many thanks everyone!

I will shortly open another question =) please answer if you know!

Obrigado ^^