I want to retrieve a set of data from one spreadsheet based on multiple
search criteria into another worksheet. For example, I work in manufacturing
and I have performance data in one sheet for a given day by shift. I have
four crews that rotate on three shifts called A, B, C, & D crews. Each shift
has its own production data in a row and the sequence of shifts rotates over
time. I've had some luck with the 'index" function, but it is not retrieving
data by date; instead only the row that I indicate. I need a function to
search the entire range and then retrieve a row of information specific to
"date and crew" that corresponds with that crews information on that day.

Below is a sample of the worksheet where entries are made that I wish to
retrieve data by date and crew from:

Date Shift Operator Crew Produced Scrap
2/1/09 1 Jones C Crew 275,000 5000
2/1/09 2 Smith A Crew 225,000 7000
2/1/09 3 Carter B Crew 325,000 4000

The summary sheet that I wish for this data to be retrieved to is similar in
format but is a much larger sheet that has multiple purposes. However, I
need the data above pulled into it. Do I need a function that is a "IF" and
"AND" statement?

Please help.
Thanks
SO