Forum Discussion

ChrisIreland's avatar
ChrisIreland
Copper Contributor
Nov 02, 2021

Drop Down List

I was wondering if someone could help. I want to add a formula to a drop-down list example: 

IFS(Interface_Funding_Type_="Refinanced",AE3:AE87,Interface_Funding_Type_="Solar Loan",AF3:AF10,Interface_Funding_Type_="Green Penny",AG3:AG4,'17. Interface'!I46="Cash","0.00%"

Is it possible for the data validation drop down capable? 

excel

2 Replies

  • Juliano-Petrukio's avatar
    Juliano-Petrukio
    Bronze Contributor
    Nov 02, 2021

    ChrisIreland 

    Yes it is possible. You just need to make some adjustments regarding Cash because as it is a static value it cannot be treated as a proper list.

    Find attachment some idea so you can start with

     

    =INDIRECT(CHOOSE(MATCH(Interface_Funding_Type_,Funding_Type;0),"AE3:AE87","AF3:AF10","AG3:AG4"))

     

    This solution can be applied for any of versions of excel.

     

  • Yea_So's avatar
    Yea_So
    Bronze Contributor
    Nov 02, 2021

    ChrisIreland 

     

    put that formula in a sheet say you name a sheet "Drop Downs" and in A1 you put that formula.

    in the data validation drop down you reference the cell =A1# 

Resources