Excel lookup form

[Urszula]

Hi, :sos:

I am trying to look up some values in Excel from another tab based on specified value as a filter. Meaning I want to enter a name in one cell and return a list of values from a bigger list that corresponds to this name. I can't use lookup function because there are multiple values that need to be returned. The closest functionality that reminds what I want to do is a subform in a form in Access. If I select one field, the subform return all the corresponding values linked based on a specified key. Any ideas besides writing VBA code?

Thanks in advance!

[Andy]

http://office.microsoft.com/en-us/excel/HA012260381033.aspx

[Urszula]

Thank you Andy. That should work.
I appreciate.