How to Select Values from a 2nd Drop-Down List in Excel

[sumithasb]

Hi Danny, I was wondering what could be the issue that BamaDomination was facing since i get the same error. Kindly request you to post the solution.

Best Regards,

Sumi

[sumithasb]

@sumithasb

I was able to figure out, though I named the list Market A excel had named the list as Market_A. So the error was due to the difference in name...

Thanks Danny , this video was great!!!

[DannyRocksExcels]

@sumithasb

Hello Sumi -

Yes, as you see, NAMED Ranges in Excel::

1) MUST begin with a Letter or an Underscore

2) Cannot contain ANY Spaces

Danny Rocks

The Company Rocks

[DannyRocksExcels]

@sumithasb

Hello Sumi -

To the best of my knowledge, I never received the Excel workbook that @BamaDomination referred to.

I have not been able to "create a scenario" that returns the error message "Source Currently Evaluates to an error."

I suspect thatpossibly:

1) The NAMED Range has been deleted

2) Error in creating a Named Range (Usied an invalid character, etc.)

3) Error in creating Data Validation - did not use the Custom - Formula or kept reference as Absolute.

Email me.

[BamaDomination]

I'm doing the exact same thing that is listed in this video, however I'm getting an error. "The source currently evaluates to an error. Do you want to continue?"

[DannyRocksExcels]

@BamaDomination

Hello! That is an "odd message" to receive. Please email me directly - you can find my email address by searching for The Company Rocks - and I will take a look at your data and your formulas.

Best wishes,

Danny Rocks

The Company Rocks