Looking up and returning multiple values

Microsoft Excel 2003 (full product)
January 29, 2010 at 08:43:39
Specs: Windows XP, 2.0/2
I have two columns, district and customers. i want to list the customers based on the users district input. vlookup will only return the first customer entry per district...any ideas?

See More: Looking up and returning multiple values

January 29, 2010 at 10:04:53

Have you tried using the filter function.

Select the the column of cells with the district data (including heading row)
From the Menu bar select Data - Filter and then AutoFilter.

This will give you a drop-down list at the top of the column.
Select a district from the drop-down and only rows containing that district name will be shown - and you will see all customers for that district.

The visible data can be copied and pasted elsewhere if required.


Report •

January 29, 2010 at 11:23:06
I believe what you are looking for can be found here:

...except that the actual formula you need is cut off.

To test the example given on that page, they show (at least on my browser)


You actually need to use:


The ",2)" is cut off on my screen.

Make sure you use Ctrl-Shift-Enter to make this an array formula.

Report •

January 29, 2010 at 12:33:28
someone gave me this link that showed how - http://office.microsoft.com/en-s/ex...

Report •

Related Solutions

January 29, 2010 at 13:25:50
How's does a link that returns "This Web page is unavailable" help you?

Report •

Ask Question