Formula

[AMZI2001]

1. I want to fetch data to display at the template if division is A is selected, all the initiative under division A listed under dropdown to be selected
2. I want to fetch data to display if Project A is selected, the template shows the prioritization and displays whether the budget type is Capex or Opex.
3. The budget approve amount, will display amount 315,000 if project A budget type is Capex

Template

No	Div	Initiative	Prioritization	Budget Type	Budget Approve Amount

Table data

Division	Initiative	Prioritization	Capex	Opex
a	Project A	P2	315,000.00
b	Project B	P1	2,400,000.00	860,000.00
a	Project C	P3		860,000.00
d	Project D	P4	5,000,000.00
c	Project E	P2		5,000,000.00
a	Project F	P3		9,140,000.00
d	Project G	P4	5,000,001.00

[#2]

anyone can help?

[#3]

@AMZI2001 

All participants here are users like you who voluntarily spend some of their free time to help others. So you cannot expect an immediate reply.

Where do you want to select division A? And could you provide an example of what the output should look like?

[#4]

The output:

Division: a
Initiative: Project A
Prioritization: P2
Budget Type: Capex
Budget Approve Amount: 315,000.00

Division: a
Initiative: Project C
Prioritization: P3
Budget Type: Opex
Budget Approve Amount: 860,000.00

[#5]

@AMZI2001 What about filter function like

=FILTER(A2:E8,A2:A8=G2)

where G2 is your dropdown cell and select a.