Merging two index function formulae effects

Hi All,

Brand new to this so hoping for some help.
I have two forumal i want to combine into one overall effect that provides a unique list based on matching a criteria.

Matching a criteria: =INDEX(Index!$D:$D,MATCH(Fetch!$F$1,Index!$B:$B,0)) [Finding a result that matches some text in F1]

Creating a full unique list: =IFERROR(INDEX(Index!$D$3:$D$51,MATCH(0,INDEX(COUNTIF($E$2:E4,Index!$D$3:$D$51),0,0),0)),"")

I want to create a full unique list from all things in the criteria, so when i input into Fetch!$F$1 a piece of text, the entire list of all unique associated values appears.

Hope it's not an impossible as it would speed my day up no end.

All help gratefully received.

It partially works, however only fetches back one result, in this case the first one as if only the criteria index is running.

Did you enter as ..????

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

It would help if you posted a sample Excel file (not image) with some expected results.

To upload a file, click "Go Advanced" then "Manage Attachments"

Hoping this works as it's first time attaching a file.

Should be on this as showing a success.

The idea is when selecting a system identifier it pulls in a unique list of data measures and then if that works a second selector from those data measures can then show a list of data points.

Thanks in advance.

See attached: I changed entries in INDEX to give more results in FETCH.

Hi Tony,

The idea is to create a formulae that pulls, based on the dropdown selected, a unique list of all the dependant or associated components from the index.

So by selecting 1 in the dropdown you would get

Data Measured Table Column
Billable Time A Phone
Unbillable time A Phone
System abscence A Phone

Hope that makes sense.

John, your solution seems to work and i'm trying a few things to put it into practice on real data so thank you hugely

@Tony,
"My" solution used the formula you provided (minor change on range) to get the unique list and then I added VLOOKUPs to get the other data.

So credit goes to you.