Multiple criteria lookup function

[daniel_ev]

I am trying to find out whether local press releases may have affected companies' decision to join a certain government program. My Excel document contains A) a list of companies, B) those companies' postal code, and C) the date those companies got in touch with people from the program.

Lpypj.png

Secondly I set up a document that contains all press releases sent out by the agency in the past year. It contains the date at which a press release was published, and the minimum and maximum value of the Postal Codes of the area covered by the press release.

1byEG.png

I am trying to write a function that checks two things:

1. Is a company's postal code within the range covered by any press release?
2. Was any of the press releases that meet those criteria sent out within three months before the initial contact date (Sheet 1, Column A)?

If both are true, the function should return a 1 or something. If not a 0 of course suffices.
How do I do this?

[oeldere]

For the other forummember, this question is also posted here.

http://www.mrexcel.com/forum/showthr...ookup-function

[daniel_ev]

Really no one who can help me out?