View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hany ElKady Hany ElKady is offline
external usenet poster
 
Posts: 7
Default 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