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

The usual way is to setup AutoFilter on the original data. You can setup
separate criteria on each of the columns and only those rows meeting the
criteria will be displayed.

Then copy the visible rows and paste elsewhere.
--
Gary''s Student - gsnu200828


"ezaz123" wrote:

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