lookup with multiple possible returns

**mheinmiller** · 03-31-2009, 12:33 PM

I need to lookup a Order Number and return all associated Item Numbers. My spreadsheet has about 10,000 lines and these Order Numbers could have as little as 1 or as many as 15 Item Numbers associated. I would like to have a drop down on each Order Number that shows the Item Numbers.

Can anyone help? I dont know where to start. I have an example of my data attached.
thanks

**modytrane** · 03-31-2009, 12:52 PM

look at the example attached.
I've created a seperate column that gives you a unique list of order numbers.
If you add a new order number, it will be added to the list. Next to each order number, it gives you a count for that order number. Formulas are written down to row 37. You can drag them as far down as you want.

Hope this helps.
modytrane

**modytrane** · 03-31-2009, 01:08 PM

same file with some added formulas.
You can list all the item numbers for each order.
You should be able to place the list of items somewhere else if you like.
modytrane