finding name within range
 

have had kind of help with this before but i need more.

i have a name that i wish to find if it is within range (range name =
"Names"). If that name (say George) is within that range, then I wish
that name to be entered into the cell with the formula. if "George"
isnt within that name, then I wish to search for "Harry" to see if
that is within the range and if so, then "Harry" to be entered into
the cell with the formula.

any help out there?

TIA
sheila

Hi Sheila
Try
=IF(ISNUMBER(SEARCH("George",Names)),"George",IF(I SNUMBER(SEARCH("Harry",Names)),"Harry","
Not Found"))

Regards

Roger Govier


sheila wrote:
have had kind of help with this before but i need more.

i have a name that i wish to find if it is within range (range name =
"Names"). If that name (say George) is within that range, then I wish
that name to be entered into the cell with the formula. if "George"
isnt within that name, then I wish to search for "Harry" to see if
that is within the range and if so, then "Harry" to be entered into
the cell with the formula.

any help out there?

TIA
sheila

no, that doesnt work, gives me "Not Found" when "George" is within the
range.

any other ideas?

TIA

=if(countif(names,"George")0,"George",
if(countif(names,"Harry")0,"Harry","not there"))

(all one cell)

may work.

sheila wrote:

have had kind of help with this before but i need more.

i have a name that i wish to find if it is within range (range name =
"Names"). If that name (say George) is within that range, then I wish
that name to be entered into the cell with the formula. if "George"
isnt within that name, then I wish to search for "Harry" to see if
that is within the range and if so, then "Harry" to be entered into
the cell with the formula.

any help out there?

TIA
sheila

--

Dave Peterson

That does it, thanks Dave, appreciate it.

Sheila



On Tue, 13 Sep 2005 20:43:52 -0500, Dave Peterson
wrote:

=if(countif(names,"George")0,"George",
if(countif(names,"Harry")0,"Harry","not there"))

(all one cell)

may work.

sheila wrote:

have had kind of help with this before but i need more.

i have a name that i wish to find if it is within range (range name =
"Names"). If that name (say George) is within that range, then I wish
that name to be entered into the cell with the formula. if "George"
isnt within that name, then I wish to search for "Harry" to see if
that is within the range and if so, then "Harry" to be entered into
the cell with the formula.

any help out there?

TIA
sheila