finding name within range

[sheila]

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

[Roger Govier]

Hi Sheila
Try
=IF(ISNUMBER(SEARCH("George",Names)),"George",IF(ISNUMBER(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

[Sheila]

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

any other ideas?

TIA

[Dave Peterson]

=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

[sheila]

That does it, thanks Dave, appreciate it.

Sheila



On Tue, 13 Sep 2005 20:43:52 -0500, Dave Peterson
<[email protected]> 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