Trying to create formula to return Movie Titles depending on Studio and Release Month

Hi,

I have two spreadsheets. The first one contains a huge list of Hollywood movies. The movies are listed in order of release date. The data is formatted into columns, like this:

Movie Title; Studio; Release Month; Budget
Movie 1; Paramount; March; $200MM
Movie 2; Universal; March; $13MM
Movie 3; Time Warner; April; $32MM
Movie 4; Paramount; Spring; $50MM
This list goes on for hundreds of titles....

I have a second spreadsheet, which contains a revenue forecast for each studio. The columns are labeled like this:

Q1 2010; Q2 2010; Q3 2010; Q4 2010

I want to create a formula that will pull in the names of the movies that will be released in each quarter into this spreadsheet.

Logically, I'm thinking something like this:

IF Studio = Paramount AND Release date = Jan, Feb, March, Winter, or Q1, then insert the name of the movie into the cell. But I don't want to repeat names of movies, and the formula needs to perhaps use VBA or something to continue searching until it finds all the movies, with each movie title being input into a different cell beneath the prior title.

I'd really appreciate it if someone can help me here. I can do this manually, but i really want to automate it in order to minimize mistakes.

Many thanks to all for the help. This is my first time posting but I come here often for assistance!

Thanks!

How does this approach look? You can hide the highlighted helper stuff.

Thanks this is very helpful. You gave me a few great ideas on how to implement this! I like the use of LOOKUPS with MATCH....very nice. Thanks again!

Actually, I have one more question. I have a revenue forecast for each studio.

So I'm looking to only have Paramount titles populate the Paramount forecast, Universal titles populate the Universal forecast, etc. Can I add a simple =If(A3 = Paramount, then put all the other code here, "")

Sorry, I neglected that piece of your original post. The attached replaces the "Forecast" tab with one for each studio. This requires that you manually create a new tab for each studio, with some formulas specific to the studio. This is somewhat clunky and doesn't work well if you have a large number of studios, so a more elegant solution would look to the tab name and then adjust the formulas accordingly. If you're interested, please let me know.