sorry but is it possble to make modification of the formula to suit this
scenario?

the scenario:

vehicle_no date in date out



in your formula the date will be assigned (based on sheet no )if a
vehicle_no

has been selected. in my sheets, the outstanding work in day 1 will be
reflected

in day 2 (sheet 2) . So if i key in the vehicle no in day one, the
date_in will be


02/10/2005 and this is not true as the vehicle is dated in on
01/10/2005.

in sheet one

vehicle no date_in date_out action taken
x123 01/10/2005 change
XXX
y456 01/10/2005 01/10/2005


in sheet two,

vehicle_no date_in date_out action taken
x123 01/10/2005 change yyy
x123 02/10/2005

over here, x123 is not dated_out in sheet one , so x123 will be seen in
sheet two

but if i key in x123 to update the action taken, the date in is
02/10/2005 which in

fact should be 01/10/2005

pls advise...


--
cjjoo
------------------------------------------------------------------------
cjjoo's Profile: http://www.excelforum.com/member.php...o&userid=26916
View this thread: http://www.excelforum.com/showthread...hreadid=476165