Forum Discussion

AMZI2001

Copper Contributor

Aug 14, 2022

Formula

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 I want to fetch data to display if Project A i...

excel

AMZI2001

Copper Contributor

Aug 23, 2022

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

Harun24HR

Silver Contributor

Aug 23, 2022

AMZI2001 What about filter function like

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

where G2 is your dropdown cell and select a.