Hi

Possible ways:

1. Use CHOOSE (in combination with MATCH, or with some numeric expression.
Up to 28 options are available.

2. Use VLOOKUP/HLOOKUP with lookup table or with array argument for lookup
values.

3. When the result will be number, you can compose the formula in form
=LogicalExpression1*Result1+LogicalExpression2*Res ult2+...+LogicalExpression
N*ResultN


Arvi Laanemets



"Nakia Allen" wrote in message
...
I am working on an Excel spreadsheet, but the summary page must check the
information in 10 to 20 cells and once it finds a match, it must become
equal
to a value in a different cell. Is there any way to have multiple IF
functions to verify a value when there are more than 7 checks (the maximum
number of nested functions)? FYI, I am comparing data strings.