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