Hello,
I am having difficulty in getting arrays to work and am paring down my problem to the basics.
What I am trying to do is find information in one cell and return the information in the cell below it.
I have the basic formula that works for one row, this is in the cell B4 and copied down the row:
offset(index($b$13:$m$13,0,match(b3,$b$13:$m$13,0)),1,0)
It works as intended, including the errors. My problem is that while I'll know the row the information could reside, I won't know which row the information is in.
I tried an array that looked like such:
{=offset(index($b$13:$m$13&$b$18:$m$18,0,match(b3,$b$13:$m$13&$b$18:$m$18,0)),1,0)}
comes back with #N/A, and when stepping through the information gathered looks off.
what am I doing wrong?
The enclosed workbook is approximate to the setup we have. Top is set as a backplane in a terminal room, bottom is set how our switches have their ports.
I am trying to find the outlet that matches on the backplane & switch. If a match is found, put the device information under the match to the cell beneath the outlet on the backplane.
Thanks for any suggestions or help you can provide.
Ken
Bookmarks