Search Engine

[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

 

[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

 

[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

 

[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")