Matching announcement date and deal value to ISIN-code

[ruben432]

Hi all,

First of all I would like to say I have tried solving it myself but i can't get the formulas working. So my problem is as following: for a research I have about 1000 stock prices, for these stock prices i need an announcement date and a deal value.

The only problem is i got the deal value and announcement date from different databases. The announcement dates(AI) and deal values(AJ) are organized by an ISIN-code(AK). So now I need some kind of trick that matches the announced date(AI) and Deal value(AJ) to columns AF and AG via the ISIN code. So in summery there are two ISIN-codes (AK & AH) and deal value (AJ) and announcement date(AI) need to be matched via this ISIN-codes.

I hope this is enough information, my excel file is attached!

Greetings,

Ruben

[HangMan]

Hi ruben,

You could simply use this in cell AF2 and copy down:

Please Login or Register  to view this content.

and then this in AG2 and copy down (formatting column AG using a date format):

Please Login or Register  to view this content.