| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Depedent Dropdown and INDIRECT($P$8) with a twist
On Monday, December 16, 2013 3:07:12 AM UTC-8, Claus Busch wrote:
Hi Howard, Am Mon, 16 Dec 2013 01:30:10 -0800 (PST) schrieb : Works in a normal cell, but in the source window of the drop down, I get an error List source must be a delimited list or a reference to a single row or column. you can't refer with INDIRECT to 2 different ranges. =INDIRECT(P8) creates the list for R8 For N8 you have to do it in the cell or with VBA. Regards Claus B. -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 Okay, good to know that. I think I have a solution using the LEFT function. Thanks, Claus. Regards, Howard |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions | Excel Worksheet Functions | |||
| Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? | Excel Worksheet Functions | |||
| depedent drop down lists | Excel Programming | |||
| populating a dropdown based on choice from a previous dropdown | Excel Programming | |||
| Programatically navigate to depedent cell(s) | Excel Programming | |||
Threaded Mode
