VLOOKUP might be an appropriate replacement for the IF.........

Vaya con Dios,
Chuck, CABGx3



"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.