because of the 7 nesting formulas limits in Excel 2003, I have four lists
named in a range spreadsheet.

What I would like is to say in I3 is that if H2 matches something in the
first list (named "Apples") enter "Apples" or if it matches something in the
second list(named "Oranges") enter "Oranges" and so on for each of the named
lists.

each cell in the named lists have unique text (nothing is repeated in any of
the lists).

Try something like this:

=IF(COUNTIF(Apples,H2),"Apples",IF(COUNTIF(Oranges ,H2),"Oranges",""))

--
Biff
Microsoft Excel MVP


"Bob" wrote in message
...
because of the 7 nesting formulas limits in Excel 2003, I have four lists
named in a range spreadsheet.

What I would like is to say in I3 is that if H2 matches something in the
first list (named "Apples") enter "Apples" or if it matches something in
the
second list(named "Oranges") enter "Oranges" and so on for each of the
named
lists.

each cell in the named lists have unique text (nothing is repeated in any
of
the lists).

worked beautifully. Thank you

"T. Valko" wrote:

Try something like this:

=IF(COUNTIF(Apples,H2),"Apples",IF(COUNTIF(Oranges ,H2),"Oranges",""))

--
Biff
Microsoft Excel MVP


"Bob" wrote in message
...
because of the 7 nesting formulas limits in Excel 2003, I have four lists
named in a range spreadsheet.

What I would like is to say in I3 is that if H2 matches something in the
first list (named "Apples") enter "Apples" or if it matches something in
the
second list(named "Oranges") enter "Oranges" and so on for each of the
named
lists.

each cell in the named lists have unique text (nothing is repeated in any
of
the lists).

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Bob" wrote in message
...
worked beautifully. Thank you

"T. Valko" wrote:

Try something like this:

=IF(COUNTIF(Apples,H2),"Apples",IF(COUNTIF(Oranges ,H2),"Oranges",""))

--
Biff
Microsoft Excel MVP


"Bob" wrote in message
...
because of the 7 nesting formulas limits in Excel 2003, I have four
lists
named in a range spreadsheet.

What I would like is to say in I3 is that if H2 matches something in
the
first list (named "Apples") enter "Apples" or if it matches something
in
the
second list(named "Oranges") enter "Oranges" and so on for each of the
named
lists.

each cell in the named lists have unique text (nothing is repeated in
any
of
the lists).