Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
comotoman
 
Posts: n/a
Default Creating and showing a list


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

  #2   Report Post  
Ruthki
 
Posts: n/a
Default


auto filter does jobs like this well - but you would select from a drop
down menu rather than entering 2/asphalt in a cell.
Excel help will guide you through using the autofilter.
r


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

  #3   Report Post  
comotoman
 
Posts: n/a
Default


I am currently using autofilter to do this, but I would like to keep the
results and do the another search to fill in for 16 divisions on one
sheet. example:

_Div_#____________Subcontractor_Work______________ _Contact_info._
"2" "asphalt"

Results
A1 Paving
123-4567
Plus Paving
456-7891
Z paving
654-3210
etc.
_Div_#____________Subcontractor_Work______________ _Contact_info._
3 concrete

Results
1 Concrete
987-6543
Mudd Works
568-9546
etc.


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

  #4   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
  #5   Report Post  
comotoman
 
Posts: n/a
Default


Thanks for all the help, but I think Im getting lost or not explaining
my needs right. I understand the filter features, but you can only
filter one time on a sheet. I need to be able to filter multiple times
in different lines on one sheet. How do I do this?


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



  #6   Report Post  
comotoman
 
Posts: n/a
Default


YEA!!!!!! I figured it out, it takes a combination of data validation
dependent list, and vlookup. Thanks to all who helped!!!


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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel XP: Showing Trace Precedents Arrows for Multiple Cells... Birmangirl Excel Discussion (Misc queries) 3 September 27th 05 03:12 PM
How can I prevent a Chart from showing zero values? Quinn Ramsey Charts and Charting in Excel 4 July 27th 05 03:39 PM
creating a chart with auto fillin of missing date points? Rob Charts and Charting in Excel 2 March 20th 05 04:12 PM
Creating time chart carina Charts and Charting in Excel 3 February 15th 05 01:44 PM
Creating customised calendars Dee Excel Discussion (Misc queries) 0 February 14th 05 05:07 PM


All times are GMT +1. The time now is 05:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"