Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Refer to "formula" in a formula

0

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

IF(ISBLANK(C8),"",=TrxTypeList)

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

Answer
Discuss

Answers

0

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

Discuss

Discussion

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: 1989) 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