Hi!

The easy way:

Use AutoFilterCustomContains

If you want something that's dynamic and uses formulas it depends on how
large the dataset is that has to be searched as to whether it would be an
efficient method to pursue.

Biff

"DSCAVOTTO" wrote in message
...
I have a table with a list of names and matching vendor numbers. I want to
create a macro or formula that takes an input entry cell "say CHI" and
would
give me a list of all names in the table (Chicago, Chicago White Sox,
Chicago
Bulls, City of Chicago etc.)

Any suggestions?

--
Dave