Hi!

I'm trying to make a spreadsheet which shows all the information about a particular client. There is a long list of clients with different information and I would like a drop down box to take that information and display it on the main page. Normally I would just use the index function but in this case there are sometimes more than one record for the same client (e.g. there could be three different barclays records). Is there a way I can display all of the rows which are related to that client using a drop down. I have quite a few columns of different information which I need to display such as date and cost.

Any help would be greatly received!

Thanks!