0

If someone could point me in the right direction I would be greatly appreciative.

I am trying to work an array formula and a data validation list (dropdown) together, so that instead of the array formula dumping the result to the sheet, it populates a dropdown with the values it finds.

Scenario:
I have a set of data like the screenshot below, what I need is to be able to specify a socket number and then be able to choose the available duct and exit values from a dropdown list.
I have tried using VLOOKUP and INDEX MATCH together with a data validation list however neither of those methods allow for multiple results.

Data:

Data

Thank you for reading.

Improve this question
4
  • It would be much easier if you add some examples, directions you've tested, etc. Commented Jan 30, 2018 at 9:00
  • I added my scenario and some dummy data, I hope this helps. Commented Jan 30, 2018 at 9:20
  • Have you tried this: stackoverflow.com/a/43047363/2193968 Commented Jan 30, 2018 at 11:16
  • I have, however with the method I'm using (array formulas, because I don't know any other way to display multiple results of a formula) this isn't possible Commented Jan 30, 2018 at 13:37
Related questions
4
How to create dropdown with multiple columns in excel
1
How can I create a formula from drop down list
0
Excel to return a list values in the dropdown
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.