Have you ever used the Index and Match functions together? You can use this
like VLookup, but with ranges. Perhaps if you reformatted your data so that
if your random date falls within a particular range you'll get on value and
if it's between another range, you'll get another range. Try that out and
let me know if this does it for you.

"barkiny" wrote:


I dont mind any changes in the data, that is only for illustration
purposes...


for example
i enter "01/05/2004" (I am not using english date system btw.. so the
months are in middle...)

when i enter 01/05/2004, i know that earnings are announcent for
company B but not company A so i should be like that

Company A Company B
01/05/2004 n.a. -17.11

but when i enter say.. 01/07/2004
it should be like
Company A Company B
01/05/2004 n.a. -17.11
01/07/2004 -4.03 -17.11


--
barkiny
------------------------------------------------------------------------
barkiny's Profile: http://www.excelforum.com/member.php...o&userid=20397
View this thread: http://www.excelforum.com/showthread...hreadid=539860