Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() 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
![]() |
|||
|
|||
![]() 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
![]() |
|||
|
|||
![]() 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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]() 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
![]() |
|||
|
|||
![]() 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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel XP: Showing Trace Precedents Arrows for Multiple Cells... | Excel Discussion (Misc queries) | |||
How can I prevent a Chart from showing zero values? | Charts and Charting in Excel | |||
creating a chart with auto fillin of missing date points? | Charts and Charting in Excel | |||
Creating time chart | Charts and Charting in Excel | |||
Creating customised calendars | Excel Discussion (Misc queries) |