Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I return dynamic lists?
Im not sure if this is even possible but I would like to retrieve and
display varying lists of data from a worksheet. The information is set out like this: Worksheet1 From a drop down menu, the user selects a job number. I would like all of the package codes and quantities that relate to that job number to be displayed. Note: there are varying packages and numbers of packages relating to each job number so the list will return different amounts of packages. (If that makes sense?) Worksheet2 PackageCode Quantity Job Number ABC 1056 1 2 3 4 DEF 3011 2 4 5 GHI 522 4 I have used VLOOKUP to return descriptions and sizes of items based on the job number but I cant seem to return the €˜dynamic lists with the package information in it. If anyone could attempt to point me in the right direction I would greatly appreciate it. |
#2
|
|||
|
|||
Hi!
Can't exactly figure out your sample data. Depending on=20 what application you use to veiw these postings, the=20 columnar data is not always aligned! Are these the job numbers: 1 2 3 4 2 4 5 4 And these, the quantities: 1056 3011 522 And these, the package codes: ABC DEF GHI Biff -----Original Message----- I=E2?Tm not sure if this is even possible but I would like=20 to retrieve and=20 display varying lists of data from a worksheet. The=20 information is set out=20 like this: Worksheet1 From a drop down menu, the user selects a job number. I=20 would like all of=20 the package codes and quantities that relate to that job=20 number to be=20 displayed. Note: there are varying packages and numbers=20 of packages relating=20 to each job number so the list will return different=20 amounts of packages. (If=20 that makes sense?) Worksheet2 PackageCode Quantity Job Number ABC 1056 1 2 3 4 DEF 3011 2 4 5 GHI 522 4 I have used VLOOKUP to return descriptions and sizes of=20 items based on the=20 job number but I can=E2?Tt seem to return the =E2?~dynamic=E2?T=20 lists with the package=20 information in it. If anyone could attempt to point me in=20 the right direction=20 I would greatly appreciate it. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match Last Occurrence of two numbers and Return Date | Excel Worksheet Functions | |||
Can't create dynamic charts | Charts and Charting in Excel | |||
How to compare 2 lists and return un-matched? | Excel Worksheet Functions | |||
Dynamic charting problems (events) | Charts and Charting in Excel | |||
Indirect and dynamic ranges | Excel Worksheet Functions |