Drop Down List

[ChrisIreland]

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? 

[#2]

@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# 

[#3]

@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.