Dependent Validation List and return value from ROW

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

Hi Dumy

You can do this, using Named Lists and INDIRECT function

Hope to helps you.

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 :=

Please Login or Register  to view this content.

Use this for the validation list in Sheet "Foglio1" B5

Name:=CountryData
Refers to :=

Please Login or Register  to view this content.

Use this for the validation list in Sheet "Foglio1" C5

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 your data for "Countries" is always 14 sequential numbers then this workbook might be worth a look.

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!!!