Put the number in ColumnA that you are looking for in Cell E1. Then, put
this function in Cell E2:
=IF(INDEX(B1:B12,MATCH(1,--EXACT(A1:A12,E1),0))0,INDEX(B1:B12,MATCH(1,--EXACT(A1:A12,E1),0)),INDEX(C1:C12,MATCH(1,--EXACT(A1:A12,E1),0)))

Commit with Ctrl+Shift+Enter (not just enter).

Regards,
Ryan---

--
RyGuy


"Hany ElKady" wrote:

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