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