If or Vlookup? need help please

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

What's wrong with the "=IF(AND" function shown in the screen shot?

As for me, I was halfway through the syntax of a SUMPRODUCT(--)>0 solution when I realized that a COUNTIFS was even better... because the OP had an almost-complete array solution, I started looking for an array answer, realized I could do it with SUMPRODUCT, then saw COUNTIFS could do it.

It wasn't the most straightforward path-to-solution I've ever walked.

Thank you so much guys, I really appreciate your quick and good response. Compared to your knowledge about excel mine should be considered at the nursery level =/

I have tried to insert your solutions but either the formula gives a wrong error or i get "#N/A" sign.

Being new I really do not know how to upload a file on this forum but I uploaded the example file on: http://www.filedropper.com/example_2

Hope you guys can help me!

best regards
Hewe

God bless you all, I have been trying to solve this for 3 days!! you guys really made my day.. ahhhh I love you and I will always hang around here to learn more!!

Thank you so much and have a great weekend!!

Best regards
Hewe

Originally Posted by itshewe

I have tried to insert your solutions but either the formula gives a wrong error or i get "#N/A" sign.

You need to adjust the syntax because what you've got in your spreadsheet is laid out differently than the sample picture.

For example:

Please Login or Register  to view this content.

In D8 and pull down.

This worked exactly as it was supposed to... based on my understanding of your needs, at any rate.

BTW, the company for stock code 8135 is "ZMFY AUTOMOBILE" on sheet1 and "ZMFY Glass" on sheet2.

Being new I really do not know how to upload a file on this forum...

Click "Go Advanced" button (or Alt+X)
Additional Options: Attachments: "Manage Attachments" button
Navigate folders & select file(s)
Click attach



EDIT:
ah, ninja'd