Vlookup With A Twist

[nebb]

I have a four column array from A1 to D50. If I use the following
formula:
=vlookup(247,A150,3,false)
when the number 247 is found in column A of the array, the contents in
the cell in column C of the same row as where 247 was found, would be
returned. I would like to return the data in cell C, not from the same
row but from the very next row. Is there any way to do this???

 

[duane]

=offset(C1,match(247,A1:A50,0),0)

or

=offset(A1,match(247,A1:A50,0),2)

 

[Bill Kuunders]

a twisty way........

=INDEX(A150,MATCH(G1,A1:A50,1)+1,3)

where G1 = 247