I need help
How to set the Dependent Validation List, but also to other dependent Validation List contains value/data from the ROW in relation to the first criteria in the first Validation List
Please see attach
Last edited by Dumy; 01-25-2012 at 08:04 AM. Reason: problem solved
Hi Dumy
You can do this, using Named Lists and INDIRECT function
Hope to helps you.
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
You might want to consider making this a bit more versatile.
1/. Put your data on a separate sheet ("Lookups")
2/. Make two named lists
Name:= Countries
Refers to :=
Use this for the validation list in Sheet "Foglio1" B5=Lookups!$A$1:INDEX(Lookups!$A:$A,COUNTA(Lookups!$A:$A),1)
Name:=CountryData
Refers to :=
Use this for the validation list in Sheet "Foglio1" C5=INDEX(Lookups!$B:$B,MATCH(Foglio1!$B$5,Country,0),1):INDEX(Lookups!$1:$65536,MATCH(Foglio1!$B$5,Lookups!$A:$A,0),MATCH(99^99,INDEX(Lookups!$1:$65536,MATCH(Foglio1!$B$5,Lookups!$A:$A,0),),1))
Once set up you can add to your Lookup Table as required without changing anything. (the data rows can have any amount of columns)
If you need any more information, please feel free to ask.
However, if this takes care of your needs, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody! ....
Also
If you are satisfied by any members response to your problem please consider using the small Star icon botom left of thier post to show your appreciation.
Hi
- Fotis1991
Thank you for the answer
This proposal of yours is OK when there are few rows.
What do you have over 100 orders.
- Marcol
Thank you for the answer
This proposal of yours is much better to resolve the problem
If your data for "Countries" is always 14 sequential numbers then this workbook might be worth a look.
If you need any more information, please feel free to ask.
However, if this takes care of your needs, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody! ....
Also
If you are satisfied by any members response to your problem please consider using the small Star icon botom left of thier post to show your appreciation.
Hi
@Dumy.Of course in this case(of many orders)my solution is not versatile. As you know i worked without many details from you(post #1).
Of course in this case, Marcol's solution, it's mutch better!
Thank you for your kind answer and also for reb*
@Marcol. Nice job!!!
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
Thank you both for answering and solutions
best regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks