View Single Post
  #5   Report Post  
Vasant Nanavati
 
Posts: n/a
Default

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

=COUNTIF(Names,"George")0

--

Vasant




"sheila" wrote in message
...
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