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.

--
Biff
Microsoft Excel MVP


"Charles" wrote in message
...
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