Yes. If you include the other column headings in the Criteria Range, you
could use multiple criteria. For instance, you could pull records for
employees hired after 06/15/2005 who earn more than $20,000.

Actually, Debra Dalgleish has some really good Advanced Filter information
on her website:

http://www.contextures.com/xladvfilter02.html

Does that help?

***********
Regards,
Ron


"gtsch" wrote:

> what would that formula look like?
> and what i want is to be able to search on any of the information and get
> all of the matches and the other info that goes along with the matches, will
> this do that?
>
> thanks
> --
> gtsch
>
>
> "Ron Coderre" wrote:
>
> > If it's not absolutely necessary to put the data on a different sheet, maybe
> > Advanced Filter will work
> >
> > If your data is in Columns A,B,C,D
> >
> > F1: hire date
> > F2: (enter a date here)
> >
> > H1: hire date
> > I1: name
> > J1: job
> > K1: salary
> >
> > Select your data range
> > Data>Filter>Advanced Filter
> > Select: Copy to another location
> > List range: (already selected)
> > Criteria Range: F1:F2
> > Copy To: H1:K1
> > Click [OK]
> >
> > That will create a listing of the records that match the critera date.
> >
> > Does that help?
> >
> > ***********
> > Regards,
> > Ron
> >
> >
> > "gtsch" wrote:
> >
> > > trying to make a database that is just a list on sheet2 and on sheet1 if i
> > > type a certain value from that database i want all of the information from a
> > > row that has that matching value
> > > ie
> > >
> > > hire date name job salary
> > > 12/01/05 JD Janitor 100
> > > 12/01/05 CJ Manager 500
> > >
> > > if i type 12/01/05 in the hire date on sheet 1 i want all of this info to
> > > show
> > > if i type JD in the name on sheet 1 i want just that row to list
> > >