Drop Down List with 2 Condition

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.