- Joined
- 12/1/07
- Messages
- 22
- Points
- 11
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!
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!