Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 28th 04, 04:57 PM
John
 
Posts: n/a
Default Dependent List Query

I am trying to set up a Dependent List and am having some difficulty. The
scenario is this

I have a list of Cities to which employees are attached to. I wish to select
a City and then only to be able to select an employee that is attached to
that list. The Cities have a Range Name "CityCol" and the Employees are
listed in columns according to the City they work in, so London employees
are in AA; Berlin AB; Paris AC ... etc

I select the City in C5 - that's not a problem I can do that. I then want to
select an Employee attached only to the City selected in C5 from a drop down
list - this is where I have hit a problem. The formula I have been
attempting to use is with Data Validation - List and is:

=OFFSET(INDIRECT($C5),0,0,COUNTA(INDIRECT(C5&"Col" )),1)

This returns an error "The source currently evaluates to an error"

Don't know if I am even using the appropriate formula

Thanks




  #2   Report Post  
Old October 28th 04, 05:26 PM
mzehr
 
Posts: n/a
Default

Hi John,
Have a lood at:
http://www.contextures.com/xlDataVal02.html


"John" wrote:

I am trying to set up a Dependent List and am having some difficulty. The
scenario is this

I have a list of Cities to which employees are attached to. I wish to select
a City and then only to be able to select an employee that is attached to
that list. The Cities have a Range Name "CityCol" and the Employees are
listed in columns according to the City they work in, so London employees
are in AA; Berlin AB; Paris AC ... etc

I select the City in C5 - that's not a problem I can do that. I then want to
select an Employee attached only to the City selected in C5 from a drop down
list - this is where I have hit a problem. The formula I have been
attempting to use is with Data Validation - List and is:

=OFFSET(INDIRECT($C5),0,0,COUNTA(INDIRECT(C5&"Col" )),1)

This returns an error "The source currently evaluates to an error"

Don't know if I am even using the appropriate formula

Thanks




  #3   Report Post  
Old October 28th 04, 06:13 PM
Frank Kabel
 
Posts: n/a
Default

Hi
another alternative:
http://www.xldynamic.com/source/xld.Dropdowns.html

--
Regards
Frank Kabel
Frankfurt, Germany

"John" schrieb im Newsbeitrag
...
I am trying to set up a Dependent List and am having some difficulty.

The
scenario is this

I have a list of Cities to which employees are attached to. I wish to

select
a City and then only to be able to select an employee that is

attached to
that list. The Cities have a Range Name "CityCol" and the Employees

are
listed in columns according to the City they work in, so London

employees
are in AA; Berlin AB; Paris AC ... etc

I select the City in C5 - that's not a problem I can do that. I then

want to
select an Employee attached only to the City selected in C5 from a

drop down
list - this is where I have hit a problem. The formula I have been
attempting to use is with Data Validation - List and is:

=OFFSET(INDIRECT($C5),0,0,COUNTA(INDIRECT(C5&"Col" )),1)

This returns an error "The source currently evaluates to an error"

Don't know if I am even using the appropriate formula

Thanks






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Extracting Values on one list and not another B Schwarz Excel Discussion (Misc queries) 4 January 7th 05 01:48 PM
Query of External Data Excel GuRu Excel Discussion (Misc queries) 2 January 3rd 05 07:43 PM
How do I find out what items are in one list but not in another l. Michelle Craig Excel Discussion (Misc queries) 2 December 22nd 04 08:32 PM
How to use a Access Query that as a parameter into Excel database query Karen Middleton Excel Discussion (Misc queries) 1 December 13th 04 07:54 PM
Counting Repeated text or duplicates in a list Repeatdude Excel Discussion (Misc queries) 5 November 26th 04 07:10 PM


All times are GMT +1. The time now is 06:34 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017