Urgent Help Needed please

[barkiny]

There are two companies (Company A and Company B)
and their earnings announcement dates are different

In the attached file, there is matrix about periods, announcent dates and the data (Net profit margin) for an example....

I want to find out:

i want to pick a random date, and it will bring the net profit margin of the company..

of course the random dates are not the same as announcent dates and when a random date is higher than announcement date it will bring the latest announcent data,, you can see in attached file

thanks in advance
Barkin

[Iskus23]

Barkiny, could you be a little more specific? Would you mind small changes
to your data, like transposing some of it?


"barkiny" wrote:

>
> There are two companies (Company A and Company B)
> and their earnings announcement dates are different
>
> In the attached file, there is matrix about periods, announcent dates
> and the data (Net profit margin) for an example....
>
> I want to find out:
>
> i want to pick a random date, and it will bring the net profit margin
> of the company..
>
> of course the random dates are not the same as announcent dates and
> when a random date is higher than announcement date it will bring the
> latest announcent data,, you can see in attached file
>
> thanks in advance
> Barkin
>
>
> +-------------------------------------------------------------------+
> |Filename: data.zip |
> |Download: http://www.excelforum.com/attachment.php?postid=4736 |
> +-------------------------------------------------------------------+
>
> --
> barkiny
> ------------------------------------------------------------------------
> barkiny's Profile: http://www.excelforum.com/member.php...o&userid=20397
> View this thread: http://www.excelforum.com/showthread...hreadid=539860
>
>

[barkiny]

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

[Iskus23]

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
>
>