Multipule Lookups???

[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

 

[David Byrne]

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,

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

 

[gilbert]

I don't know how many multiple you are looking into...but here is
sample using Sumif and Lookup....take a look at the enclosure, it migh
help you...

Attachment filename: multiple lookup.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=40835