Excel lookup form

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!
 
Top