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!