Search Engine

C

cnnsos

I have created a list of names (1000+) for people to look up. Is i
possible to create a search engine or something so that ppl can onl
type in a name and see if it is on the list, without seeing the ful
list of names
 
J

jeff

Hi,

There are a couple ways to do this. but do you want them
to see partial names? ex: key in Mc, get nothing; or
get McAbrams, McBrown, McDonalds, etc? What would be
your rules?

jeff
 
G

Gord Dibben

Yes.

It is called "Autofilter" and can be reached at
Data>Filter>Autofilter>Custom>Equals(or contains) "the name".

If you can use VBA macro a basic one would be similar to this.....

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 8/5/2004 by Gord Dibben
'

'
Range("C1").Select
Selection.AutoFilter
Selection.AutoFilter Field:=1, Criteria1:="=monday", Operator:=xlAnd
End Sub

Gord Dibben Excel MVP
 
D

Dave Peterson

Say your list of valid names is on sheet2 in column A.

Then using sheet1, use A1 as the data entry cell and B1 as a Warning cell.

=if(isnumber(match(a1,sheet2!a:a,0)),"ok","Not on list")
 
Top