Alternative to the limitations of the 'IF' function in Excel?

[Charles]

Is there any Alternative to the limitations of the 'IF' function in Excel?

Would like to return more than 7 text values contianed on another tab within
my workbook based on one value

 

[T. Valko]

You can probably use some kind of lookup formula.

Describe what you're trying to do in more detail. Post an example of your
nested IF formula.

 

[Gord Dibben]

VLOOKUP?

INDEX(MATCH?


Gord Dibben MS Excel MVP

 

[Pete_UK]

You could have a construct like this:

=IF( ... ) & IF( ... ) & IF( ... ) & IF( ... ) ...

and so on, where each IF could return one text value or "".

Hope this helps.

Pete