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