Forum Discussion
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...
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.