Maybe, in the next cell you should put
=IF(A53="","",A53+1)

And then follow it up with your VLOOKUP

Mangesh


"andrewm" wrote in
message ...

Hi Mangesh

=if(A53="","",vlookup(index(f52:f61,(match(a53,e52 :e61,0))),h52
:i61,2,false)
)

this works, however

a53 is a date

when I put in the next cell (a53+1) as the next day it doesn't work

ie.
=if((A53+)="","",vlookup(index(f52:f61,(match((a53 +1),e52:e61,0))),
h52:i61,2,false)
)

any ideas.

andrewm


--
andrewm
------------------------------------------------------------------------
andrewm's Profile:
http://www.excelforum.com/member.php...o&userid=23130
View this thread: http://www.excelforum.com/showthread...hreadid=385168