• C++ Programming for Financial Engineering
    Highly recommended by thousands of MFE students. Covers essential C++ topics with applications to financial engineering. Learn more Join!
    Python for Finance with Intro to Data Science
    Gain practical understanding of Python to read, understand, and write professional Python code for your first day on the job. Learn more Join!
    An Intuition-Based Options Primer for FE
    Ideal for entry level positions interviews and graduate studies, specializing in options trading arbitrage and options valuation models. Learn more Join!

Excel lookup form

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