I've studied a lot of post and can't find what i need so here goes. Forgive
me if i missed it somewhere.

sheet 1 contains the following data:

A B C D E
1 Date Invoice# Job Name Class Amount
2 4/5/09 546321 South Rough 23.16
3 4/6/09 546322 South Trim 57.42
4 4/7/09 546323 South Rough 89.30
5 4/7/09 546324 North Rough 1.23

I want sheet 2 to look like the following:

A B C D E
1 Rough
2 South
3 Date Invoice# Job Name Class Amount
4 4/5/09 546321 South Rough 23.16
5 4/7/09 546323 South Rough 89.30


because I told it to search sheet1!A2:E5and find whatever criteria that I
input into Sheet2 A1 and A2.
Then return the row in sheet1 that met both criteria from a1 and a2 to the
next available row on sheet 2 (ignoring the header rows)
I hope this makes sense...it does in my head :-)