Data Validation not seeing My Dynamic Range PLEASE HELP

[bamaisgreat]

I had the great idea of changing some of my named ranges to Dynamic Ranges.
I did not research this before doing so, now nothing shows up in my drop downs.
All I have in the Data Valadation Source Box is =INDIRECT (I28)
I have read that Dynamic and Indirect dont go together.
If someone could would you Please modify =INDIRECT (I28)
so it will work. This is very frustrating.
Thank you all

 

[Andrew Poulsom]

Re: Data Valadation not seeing My Dynamic Range PLEASE HELP

INDIRECT won't resolve a dynamic reference. Why do you need to use INDIRECT?

 

[bamaisgreat]

Re: Data Valadation not seeing My Dynamic Range PLEASE HELP

Andrew I have no Idea why im using INDIRECT, i probably researched it when I first made the worksheet at thats what i found. I28 contains DV also and the source box =TYPE ,
Depending on the selection in that cell depends on which Dynmaic Range it Looks at.
I dont have real good understanding of how all this works I have just always managed to patch it all together but this is way out of my league.

 

[Andrew Poulsom]

Re: Data Valadation not seeing My Dynamic Range PLEASE HELP

You won't be able to use INDIRECT with dynamic names for a dependent dropdown. How many items are there in list TYPE?

 

[bamaisgreat]

Re: Data Valadation not seeing My Dynamic Range PLEASE HELP

5 items

 

[Andrew Poulsom]

Re: Data Valadation not seeing My Dynamic Range PLEASE HELP

Look here:

Excel Data Validation -- Dependent Lists

 

[T. Valko]

Re: Data Valadation not seeing My Dynamic Range PLEASE HELP

Andrew I have no Idea why im using INDIRECT, i probably researched it when I first made the worksheet at thats what i found. I28 contains DV also and the source box =TYPE ,
Depending on the selection in that cell depends on which Dynmaic Range it Looks at.
I dont have real good understanding of how all this works I have just always managed to patch it all together but this is way out of my league.

5 items

Is TYPE a range of cells?

Here's an example.

Book1
	A	B	C
1	Type1	Type2	Type3
2	36	4	97
3	22	_	10
4	26	_	54
5	74	_	57
6	_	_	64
7	_	_	_
8	_	_	_
9	_	_	_
10	_	_	_
Sheet1

Those are your dynamic ranges.

Type refers to A1:C1

G1 is a drop down list and the source is =Type.

You want to get the sum of the dynamic range selected from the drop down in G1:

=SUM(CHOOSE(MATCH(G1,Type,0),Type1,Type2,Type3))

 

[bamaisgreat]

Re: Data Valadation not seeing My Dynamic Range PLEASE HELP

Thanks for your reply. Here is the workbook Im working on. Its a bit sloppy but I use it for mainley testing code.
https://skydrive.live.com/redir?resid=BC39913B0562FDC9!866&authkey=!AJ5JnQ5H8wPFBPk

The first DV is in Column C

 

[Andrew Poulsom]

Re: Data Valadation not seeing My Dynamic Range PLEASE HELP

Did you look at the link in Post #6? I didn't ask to see your workbook.

 

[bamaisgreat]

Re: Data Valadation not seeing My Dynamic Range PLEASE HELP

Thanks Andrew, yes I looked at the link. I posted the workbook becauce Valko replied and I wanted to show him what I was talking about.
Looking over the link it seems finda fuzzy as what exactly I am to do. If I was starting from scratch it would make more since. Im just not sure how to fix what i have.
I take it that instead of INDIRECT it wants me to use =OFFSET(INDIRECT($E2),0,0,COUNTA(INDIRECT(E2&"Col")),1) somehow.
I had read that on that link a couple of years ago when I created the workbook and didnt understand it.