Search for string and return the cell directly below in next row

[rknudson]

I am trying to find a string and return the row below the cell it finds

Formula to find the cell alone works, but not when I include it in my hypertext formula it returns row 1 and can't get it to return row 2? So confused

ctciep01.xlsx
	E	F	G
2
3	hudson.ap.org	hudson.ap.org	[ctciep01.xlsx]Objects!$C$2
4	score.ap.org	[ctciep01.xlsx]Objects!$C$5
5	split1.ap.org
6	split2.ap.org
7	susie.ap.org
8
9
10
Groups

Cell Formulas
Range	Formula
G3,F4	G3	=CELL("address",INDEX(Objects!$C$1:$C$3240,MATCH($E3,Objects!$C$1:$C$3240,0)+1,1))
F3	F3	=IF(ISERROR(HYPERLINK(CELL("address",INDEX(Objects!$C$1:$C$3240,MATCH($E3,Objects!$C$1:$C$3240,0),1)),$E3)),"",HYPERLINK(CELL("address",INDEX(Objects!$C$1:$C$3240,MATCH($E3,Objects!$C$1:$C$3240,0)+1,1)),$E3))

Range I am searching in trying to return the row below the searcg criteria

ctciep01.xlsx
	C	D	E
1	hudson.ap.org
2	165.1.3.61
3	score.ap.org
4	165.1.3.60
Objects

 

[Radoslaw Poprawski]

is this what u wished for?

Book5
	A	B	C
1
2	hudson.ap.org	165.1.3.61	165.1.3.61
3	score.ap.org	165.1.3.60	165.1.3.60
4	split1.ap.org
5	split2.ap.org
6	susie.ap.org
7
Sheet1

Cell Formulas
Range	Formula
C2:C6	C2	=XLOOKUP(A2:A6,Sheet2!A1:A4,OFFSET(Sheet2!A1:A4,1,0),"",0,1)
B2:B6	B2	=XLOOKUP(A2,Sheet2!A1:A4,OFFSET(Sheet2!A1:A4,1,0),"",0,1)
Dynamic array formulas.

Book5
	A
1	hudson.ap.org
2	165.1.3.61
3	score.ap.org
4	165.1.3.60
Sheet2

 

[rknudson]

is this what u wished for?

Book5
	A	B	C
1
2	hudson.ap.org	165.1.3.61	165.1.3.61
3	score.ap.org	165.1.3.60	165.1.3.60
4	split1.ap.org
5	split2.ap.org
6	susie.ap.org
7
Sheet1

Cell Formulas
Range	Formula
C2:C6	C2	=XLOOKUP(A2:A6,Sheet2!A1:A4,OFFSET(Sheet2!A1:A4,1,0),"",0,1)
B2:B6	B2	=XLOOKUP(A2,Sheet2!A1:A4,OFFSET(Sheet2!A1:A4,1,0),"",0,1)
Dynamic array formulas.

Book5
	A
1	hudson.ap.org
2	165.1.3.61
3	score.ap.org
4	165.1.3.60
Sheet2

I can make that work. Thank you for the suggestion !

 

[Radoslaw Poprawski]

Glad to help