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