Refer to "formula" in a formula


Hi .

I am trying to fill in a cell based on the contents of another cell.  Specifically, I want to fill the cell with a Drop Down List that I have defined in another worksheet and labeled accordingly.

My formula looks like this .........


I am trying to insert the formula into "Sheet 1", while I have the Drop Down List defined (and labeled) in "Sheet 2".

My Excel file is attached

Can somebody please help me?

Thank you




You have to define the name in the workbook that you want to use it in.

Also, remove the equals sign from in front of TrxTypeList and add one before IF



So I have moved the contents of my drop down list, and the drop down list itself to Sheet 1.  However when I put the formula in to refer to my Drop Down List it returns a 0 (zero) instead of the drop down list.

I understand why it's returning a 0 (zero) but I want it actually to return the defined Drop Down List that's labeled as "TrxTypesList".

New file is attached for your review.

What am I doing wrong?

Thank you in advance
wickman900 Nov 8, '16 at 8:02 pm
The drop down list itself must be on the first sheet. Linking to a cell that has a drop down list in it will not recreate that drop down list.
don (rep: 1825) Nov 10, '16 at 9:02 am
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login