Using the returned cell address to find value in the next cell

[Morrighain]

I have a range of port numbers and what they are assigned to. I am using the address function to return the location of the first unassigned (blank) port in the list. How can I use that cell address to find the value in the adjacent cell.

Column A is port values
Column B is what the port is assigned to
Address function used to return the location of the first blank cell in Column B.

A / B
10000 / DRYER
10001 /
10002 / HOOD
The formula I am using to find the first blank cell is =CELL("address",INDEX(B1:B3,MATCH(TRUE,ISBLANK(B1:B3),0)))
This gives me cell B2, how do I take that result and return the value in A2

 

[Joe4]

Change the range you are indexing/pulling back from:

=CELL("address",INDEX(A1:A3,MATCH(TRUE,ISBLANK(B1:B3),0)))

 

[Fluff]

No need for the address, you can use

=INDEX(A1:A3,MATCH(TRUE,ISBLANK(B1:B3),0))

 

[Joe4]

Aah, my update returns the address of the cell meeting your requirements in column A.
I missed that you want the value of that cell, not an address, like your current formula is doing now.
Fluff got it right.

 

[Morrighain]

No need for the address, you can use

=INDEX(A1:A3,MATCH(TRUE,ISBLANK(B1:B3),0))

Thank you as usual I was way over complicating it.

 

[Fluff]

Glad we could help & thanks for the feedback.