Select value and return table with corresponding values

  • Thread starter Thread starter Isa
  • Start date Start date
I

Isa

Hi,

I have a large table which lists different cities for a region.
I want to be able to look up a region, and for the list of cities to be
returned.
With VLOOKUP, I am only able to return the first city listed in the region
for example.
Is there a way of returning the total list instead?

Thanks.
 
Hi,

You might consider Auto Filter or a Pivot Table, but if you want to use a
formula:

=INDEX(C$1:C$100,LARGE((B$1:B$100=A$19)*ROW(B$1:B$100),ROW(A1)))

This fomula is array entered - Press Shift+Ctr+Enter to enter it. I am
looking up the item in A19 in the range B1:B100 and then bringing back the
corresponding item from column C.


If this help please click the Yes button
 
Back
Top