indexing and vlookup multiple information

[Jay7]

I am trying to index and match information and trying to show the multiple values that go with it. Then I am trying to do the same with vlookup.

[DonkeyOte]

Have you thought of using a Pivot Table - it will be much more efficient long term I suspect.

To illustrate, using your sample file, push that data A1:C6 into a Pivot Table and setup as follows

ROW FIELD: Name, Buildings
DATA FIELD: Number (set to SUM if not already)

You can right click on Name select Field Settings and then go to Advanced section to list results in order of their "total" number and/or restrict to show only Top n records etc... if that's the basic premise.

In contrast to the above a formula based approach will IMHO be inefficient.

[Jay7]

I tried that, but didn't work. It seperated the information ok, but I need to be able to show my boss the top five and the multiple values that go with it. This is why I need a formula that can show multiple values.

[DonkeyOte]

I don't think you quite followed my instructions in regard to my point re: advanced Top "x" etc...

Post a more exhaustive sample wherein some values present are not be listed given they reside outside the top x requirement - we can then provide you with a proof of concept.

[Jay7]

I tried your pivot table advanced suggestion and it did work perfectly.

Thanks!