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