I would like to know how I can work with a vlookup kind of function in
which I try to lookup a value that is ocurring one row above or below
the 'specified value'.

Example:

I have a list of data and values

01/01/2000 value x
02/01/2000 value y

Now I would like to make a lookup for the value of the cell one row
above 02/01/2000, so it returns value x.

Sollutions cannot be:
-specify directly on the 01/01/2000 row
-cannot also use the date-1

Reasons are quite complicated to explain, but it should work as
described above. Does it exist and can someone help me?

Thanx!


--
broer konijn
------------------------------------------------------------------------
broer konijn's Profile: http://www.excelforum.com/member.php...o&userid=34402
View this thread: http://www.excelforum.com/showthread...hreadid=551328