Lookup and retriving more than 1 line

[S Powell]

Hi everyone,

I am trying to create a report that pulls through data with more that one line when a certain criteria is selected from a list. For example if I select a country I want it to pull through everything that is against that country. I tried a basic lookup but that only pulls through one line when I know it can have up to 6 lines of different data. Any help would be greatly received. Thanks

 

[Sam_D_Ben]

May i know what do you mean by lines. Is it a set of cells in a row on in columns. Ty

 

[S Powell]

Hi, the data is in rows

 

[Sam_D_Ben]

Something similar to yours has been addressed before. Could you please check the link below. Ty

https://www.mrexcel.com/forum/excel-questions/1106472-vlookup-alternative-multiple-vales.html

 

[S Powell]

Thanks you I will have a look.

 

[S Powell]

Following on from this if I have a list of 4 countries which are all the same, for example, and they are in a column and they have a row each of different data, how can I pull this through when you select the country from a list