A2 contains the Port ID you are searching for.
Data starts in A5 (using columns A:C)
D5 contains the formula: =OR(B5=$A$2,C5=$A$2)
D5 also contains Conditional Formatting, using the formula: =D5=TRUE

Fill the formula in column D down alongside your data.
If you put titles over your data in row 4, then you will be able to
use the AutoFilter to display all of the found items (col 4 will equal true).
--
Jim Cone
Portland, Oregon USA



"Hany ElKady"

wrote in message
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