| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup problem want 2 or more results
Hi, I have this list;
customer id invoice no. 300100 123 300100 456 300200 654 My question is; which invoices do customer 300100 have? I want answer; no. 123 and 456. How can I use Lookup to give me this result? -- Best regards Pellepannekake |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lookup problem want 2 or more results
Hi
You could mark your data and choose DataFilterAutofilter Use dropdown on Customer ID and you will see a filtered list of their Invoice numbers. -- Regards Roger Govier "pellepannekake" wrote in message ... Hi, I have this list; customer id invoice no. 300100 123 300100 456 300200 654 My question is; which invoices do customer 300100 have? I want answer; no. 123 and 456. How can I use Lookup to give me this result? -- Best regards Pellepannekake |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get correct results when LOOKUP with calculated numbers | Excel Worksheet Functions | |||
| multi sheet lookup with multiple results | Excel Discussion (Misc queries) | |||
| Odd problem with LOOKUP | Excel Discussion (Misc queries) | |||
| LOOKUP problem!!! | Excel Worksheet Functions | |||
| Lookup Function Problem | Excel Discussion (Misc queries) | |||
Linear Mode
