Broer,

Don't use vlookup. Use Index and Match.

=INDEX(A1:B4,MATCH(D1,A:A,0)-1,2)

* A1:B4 is your data table
* D1 is the value that you are looking for
* AA tells it to look for the value of D1 in column A
* the -1 means look in the row above
* 2 means take the result from the 2nd column of data (you could replace
that with another MATCH if you wanted.

Please give me a green tick (correct answer) if this is right. I am trying
to score points (only 3 so far).

thanks!
--
Allllen


"broer konijn" wrote:


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