If or Vlookup?

[itshewe]

Currently I am working with my data collection on my master thesis and I am trying to figure out which formula to use in order to gather together the information from two different sheets on Excel.

For example

Sheet 1: I have stock with the code nr of "8135" and daily stock return for this stock between 21/10/2013 and 20/02/2014


Sheet 2: I have announcements made by different companies between the time interval of 24/10/2013 and 14/02/2014


What I wan to achive is whether I can create a formula which finds that "If the "stock code" in sheet 1 is equal to the "stock code" on sheet 2 AND if the date on sheet 2 is equal to the date on sheet 2 THEN write Announcement or else nothing.


Maybe the picture below illustrates the example better, the red "announcement" columns is what i want to achieve.


http://s15.postimg.org/3u5qc2ih7/if_or_vlookup.jpg




Please let me know if it is achieveable an if so how or if you need further information.


Thanks in advance

 

[Redwolfx]

You will need to use an index/Match Array Formula

Something like

=Index(Range of Announcements,Match(Range of Stock Codes & Range of Dates,Sheet2 Range of Stock Codes & Sheet2 Range of Dates,0),1) confirmed with Ctrl + Shift + Enter

For Example

In this Example Sheet2!C1:C10000 are Announcements
A1:A10000 = Codes
B1:B10000 = Dates
Sheet2!A1:A10000 = Codes
Sheet2!B1:B10000 = Dates

=Index(Sheet2!C1:C10000,Match(A1:A10000&B1:B10000,Sheet2!A1:A10000&Sheet2!B1:B10000,0),1) Confirmed with Ctrl + shift + Enter

 

[itshewe]

Dear Red,

Thank you for your answer but I still can't manage to pull it off as it gives me error sign "#N/A". I can't figure out what I am doing wrong.

Is there any way I can send you my file with only one example and maybe you can edit it for me?

Best regards
Hewe