How do I retrieve data based on multiple search criteria?
 

I want to retrieve a set of data in a row based on multiple search criteria
from one worksheet into another. For example, I work in manufacturing and I
have performance data in one sheet for a given day by shift. For any day, I
have three shifts called A, B, C, or D. Each shift has its own production
data in a row and the sequence of shifts rotates over time, i.e, day 1 =
B,C,D; day 2 = B,A,D, etc. In another sheet called "summary," I want to
retrieve a shift's production data by date and shift. My data in both
sheets is set up in rows corresponding to the day of the month. For example,
row 2 corresponds with Feb 1, row 3 corresponds with Feb 1, and row 4
corresponds with Feb 1. This format keeps all three shifts in one group of
rows with a subtotal in row 5. Feb 2 corresponds with rows 6, 7, & 8, and so
on.