Return multiple results based on a variable cell.

Surferol

New Member
Joined
Apr 9, 2021
Messages
17
Office Version
  1. 365
Platform
  1. MacOS
Hi,
I want to use the value of a drop down box (already setup) to produce a list of identifiers from another sheet.
In the 2 screenshots, the yellow box of the timeline tab will be a drop down box, this will be the responsible units.
I want to select a responsible unit and all the ID names associated that unit is responsible for will automatically fill in in column B.

Thank you in advance,
 

Attachments

  • Screen Shot 2021-04-22 at 16.25.51.png
    Screen Shot 2021-04-22 at 16.25.51.png
    45.7 KB · Views: 28
  • Screen Shot 2021-04-22 at 16.28.10.png
    Screen Shot 2021-04-22 at 16.28.10.png
    31.4 KB · Views: 24

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
Maybe something like
Excel Formula:
=FILTER(Sheet1!A2:C1000, Sheet1!Z2:Z1000=A5)
 
Upvote 0
Maybe something like
Excel Formula:
=FILTER(Sheet1!A2:C1000, Sheet1!Z2:Z1000=A5)
Thank you Fluff,
That cam up with #Spill
 

Attachments

  • Screen Shot 2021-04-22 at 16.45.23.png
    Screen Shot 2021-04-22 at 16.45.23.png
    26.8 KB · Views: 11
Upvote 0
Just put it in one cell, and clear all the other cells.
 
Upvote 0
Thank you Fluff,
That cam up with #Spill
Hi again Fluff,
So I removed the cells with other info and the spill worked perfectly.
However, I only want to return one result not all the other data associated with the responsible unit. Only the ID
 
Upvote 0
Just change the ranges to suit.
 
Upvote 0
Hi again Fluff,
So I removed the cells with other info and the spill worked perfectly.
However, I only want to return one result not all the other data associated with the responsible unit. Only the ID
I got it, I just told it to search the one column and it is doing what I want.

Thank you once again for your help.
 
Upvote 0
You're welcome & thanks for the feedback.
 
Upvote 0
You're welcome & thanks for the feedback.
Hi Fluff,
I want to do a bit more with this. I've made the yellow box selectable for different options. Any of the options will return the results associated with the selected option.

If I make an option for "All" what can I do to return all results from the index?
 

Attachments

  • Screen Shot 2021-04-27 at 16.33.42.png
    Screen Shot 2021-04-27 at 16.33.42.png
    98.8 KB · Views: 17
Upvote 0
How about
Excel Formula:
=IF(A1="All",INDEX(CLSDIndex[ID],),FILTER(...
 
Upvote 0

Forum statistics

Threads
1,223,893
Messages
6,175,240
Members
452,621
Latest member
Laura_PinksBTHFT

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top