Vlookup With A Twist
 

I have a four column array from A1 to D50. If I use the following
formula:
=vlookup(247,A1:D50,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???


--
nebb
------------------------------------------------------------------------
nebb's Profile: http://www.excelforum.com/member.php...fo&userid=8981
View this thread: http://www.excelforum.com/showthread...hreadid=387694

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

or

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


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=387694

a twisty way........

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

where G1 = 247

--
Greetings from New Zealand
Bill K

"nebb" wrote in message
...

I have a four column array from A1 to D50. If I use the following
formula:
=vlookup(247,A1:D50,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???


--
nebb
------------------------------------------------------------------------
nebb's Profile:
http://www.excelforum.com/member.php...fo&userid=8981
View this thread: http://www.excelforum.com/showthread...hreadid=387694