| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I create a list of links (A to B) & search for both A & B
I am trying to create a list of cables in a cable rack. Thus each cable is
linking two points A & B. I have created three columns as follows A B C Cable# Port A Port B 0001 F/1 F/2 0002 F/3 F/4 and so on... Now I want to create a search to find out which cable is connected to port F/2 for instance. As you can see here I have to search both columns B&C to find the answer, and i am lost on an easier way of representing the data, or doing the search. -- Hany ElKady IT Consultant |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I create a list from the results of a file search in Excel? | Excel Discussion (Misc queries) | |||
| EXCEL - LINKS cannot easily get list of all links & names in book | Excel Worksheet Functions | |||
| Is there a way to create a drop-down list of links in Excel? | Excel Worksheet Functions | |||
| Create a search Field within a worksheet to search command buttons | Excel Programming | |||
| How do I create a "List If" function.I need to search a database . | Excel Worksheet Functions | |||
Threaded Mode
