Lookup value and return value of cell in a different row

[chiron]

Is there a way to return the value of the cell that is in the colum_index_num column but one row below the matching row? As in if the match is found in A10 then I want to get value from E11.

 

[AhoyNC]

Something like this:

Excel Workbook
	A	B
9	Find	N3
10	4
Sheet

 

[AhoyNC]

Sorry didn't get all of example posted in above.

Excel Workbook
	A	B	C	D	E
1	Name				Data
2	N1				1
3	N2				2
4	N3				3
5	N4				4
6	N5				5
7
8
9	Find	N3
10	4
Sheet

 

[chiron]

Thanks. Need to learn about index and match. Looks like it might be more useful than vlookup.