Drop Down List with 2 Condition

[Zef]

Hello All

I would like to ask for the formula since I am having a hard time in identifying what is the correct formula on my excel. Here's the scenario.

[Data Tab] On the Category column (Column G) if its " Information Security" it will get only get the corresponding id only in "CF Project" (Column A)

When i go to Details Tab, when i filter the "Information Security" (Column A from [Data tab]) it will only show the ID from "CF Project"

I have attached the excel for your reference.

Hope someone can help me on this one.

Thank you so much.

[AliGW]

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.

[JohnTopley]

This ??

In A2 of "Details"

=IFERROR(INDEX(Data!$A$2:$A$1000,AGGREGATE(15,6,ROW($A$2:$A$1000)-ROW($A$2)+1/(Data!$G$2:$G$1000="Information Security"),ROWS($1:1))),"")

Copy down

[Zef]

Hello John

Thank you for your prompt response. I copy the formula that you have provided it did get the entity id from Data tab however on the Details tab the result was not in order.

Here i have attached the file.

[AliGW]

Did you say that it had to be in some sort of sort order???

[JohnTopley]

Try

=IFERROR(INDEX(Data!$A$2:$A$2000,AGGREGATE(15,6,(ROW(Data!$A$2:$A$2000)-1)/(Data!$G$2:$G$2000="Information Security")/(Data!$A$2:$A$2000<>""),ROWS($1:1))),"")

[Zef]

Hello John

Thank you so much for your help. You remarks on this matter i highly appreciated.

I will tagged this thread as [Solved]