finding if name within range

S

sheila

If i have a range, lets name it "Names" and i want to find if the name
George is in that range, what formula should I use?

TIA
sheila
 
C

Cutter

Use the COUNTIF() function.

=COUNTIF(Names,"George")

This will give you a count of the number of times George is there
 
V

Vasant Nanavati

I *think* Anne may have misread the question. Try this function:

Function IsGeorgeInThere() As Boolean
Dim c As Range
For Each c In Range("Names").Cells
If c = "George" Then
IsGeorgeInThere = True
Exit Function
End If
Next
End Function
 
V

Vasant Nanavati

Sorry, I just realized you wanted a formula. Try:

=COUNTIF(Names,"George")>0
 
V

Vasant Nanavati

Cutter, I think your PC clock may be wrong (or the time zone is incorrectly
set) ...
 
S

sheila

Kind of right, but if the name George does appear in the range, I want
that name (George) to appear in the cell that has the formula.

how do i do that?


TIA
sheila
 
S

sheila

and i guess i should also add, IF the name George doesnt appear in the
range, then I would like something else searched and used (say
"Harry"),,does that make sense??
 
Top