match a cell reference with a series of lists

[Bob]

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

 

[T. Valko]

Try something like this:

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

 

[Bob]

worked beautifully. Thank you

Try something like this:

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

 

[T. Valko]

You're welcome. Thanks for the feedback!