Multipule Lookups???

  • Thread starter Thread starter Scott V.
  • Start date Start date
S

Scott V.

I have an need to do a multiple lookup beyond the standard
singular V & HLOOKUP and am wondering if there is another
way to perform this task, hope you all can help...

I have a spread sheet that contains several columns of
which the most important are the date and job name. I need
a lookup that will find all of the data with the same date
and job name and place that into another sheet. For
instance i am trying to create a package slip from my
general log which contains the data. I need this lookup to
pull up not only the first item for that day and job but
all of the items that pertain to that job and day, perhaps
there maybe as many as 20 different items. hope that gives
you enough info...

Scott
 
Scott V. said:
I have an need to do a multiple lookup beyond the standard
singular V & HLOOKUP and am wondering if there is another
way to perform this task, hope you all can help...

I have a spread sheet that contains several columns of
which the most important are the date and job name. I need
a lookup that will find all of the data with the same date
and job name and place that into another sheet. For
instance i am trying to create a package slip from my
general log which contains the data. I need this lookup to
pull up not only the first item for that day and job but
all of the items that pertain to that job and day, perhaps
there maybe as many as 20 different items. hope that gives
you enough info...

Scott
Click to expand...

Scott,

You will find Pivot Tables amazing, but it may be that all you need to
do is some creative filtering.

Check out Auto Filter and Advanced Filter

Explore and Enjoy

David Byrne

Melbourne Australia
 
Back
Top