# Re: Is there any way around the maximum of seven nested functions?

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

Vaya con Dios,
Chuck, CABGx3

"Nakia Allen" <NakiaAllen@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FA643496-06AC-46E8-BB71-98B14A47EAAE@xxxxxxxxxxxxxxxx
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.

.

## Relevant Pages

• Re: how can i multiply two columns
... dwtand column b is grain. ... Vaya con Dios, ... it will return zero if either of the two cells are ... "edgar" wrote: ...
(microsoft.public.excel.worksheet.functions)
• Re: Concatenate cells
... This method is a process.....involving several cells ... Vaya con Dios, ... "Snakeoids" wrote: ...
(microsoft.public.excel.misc)
• Re: Create named range of cells with values in row
... Vaya con Dios, ... End Sub ... hopefully the macro would also work with text values....no formulas now, ... what is in your cells... ...
(microsoft.public.excel.programming)
• RE: IF(ISTEXT Concatenate formula question
... Vaya con Dios, ... "SCrowley" wrote: ... empty cells to make sure there were no spaces OR non-printing characters. ... I have a formula that concatenates cells if they have text and inserts ";" ...
(microsoft.public.excel.worksheet.functions)
• Re: VBA for Text/Cells merge
... You're welcome Ron, and it's good to see you figured out how to edit it ... Vaya con Dios, ... Please disregard my earlier post re the CHARinsert ... Col B varies on a daily basis but is rarely less that 1500 cells. ...
(microsoft.public.excel.misc)