VLOOKUP to return multiple values

Hi All,

I have a list of countries in column A, there are duplicates in this list. In column B are numbers corresponding to the country.

A B
IRELAND 1221
GERMANY 2341
USA 3443
IRELAND 2231

Ireland could be in the list and have up to 20 different values beside it in column B

On a separate sheet i have a drop down list of all the countries. I am looking for a vlookup or something similar to return a list of all the numbers beside IRELAND when Ireland is selected in the drop down list.

I had been trying a vlookup but this looks at the list and stops at the first "IRELAND" it finds and just returns the value beside the first "IRELAND"

any help be great

Simon

Hi,

This can be easily done using a Pivot Table. Please post a sample template of your workbook using "Go Advanced" option below.

Thanks for the quick reply,

the link Ace_XL suggested worked perfect for me. Rep Added

Simon