Excel has a feature that does almost what you want.

Select your range
data|filter|autofilter

You'll see dropdown arrows for each column in that selected range.

You can use those dropdown arrows to choose from a list of your entries.

You can also choose Custom and use contains or begins with or ends with or....

Then you can show what you want.

And you can filter on each column to further shrink down the number of displayed
rows.

When you want to see all the data again, just
data|filter|show all.
(or choose (All) from each of your filtered columns.)

Debra Dalgleish has some nice instructions at:
http://contextures.com/xlautofilter01.html



comotoman wrote:

I have a phone list divided into many catagories: a=Div#, b=what they
do, c=Contact info. Im trying to create a lookup feature that allows
the user to look up a div#, and show all. Or lookup what they do and
show the contact information. for example. In div2, I have 13 asphalt
subcontractors, in the cell "div#", I would like to type "2", then
below that in another cell, I would like to type "asphalt" and the
result would be ALL 13 asphalt subcontractors.

--
comotoman
------------------------------------------------------------------------
comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292
View this thread: http://www.excelforum.com/showthread...hreadid=467934

--

Dave Peterson