Indirect function

[Tornado1981]

hi,

Can anyboby plz help me solving this problem ?
I have 3 cells (A1,B1 & C1)
In A1 I have a data validation list named "AAA" and containing "USA" & "Canada"
In B1, a data validation list named "BBB" and containing "States" & "Cities"

What I want to do is that:
1) If I choose USA from A1 and States from B1 .. A list containing "Texas","California" & "Illinois" appears in C1.
2) If I choose USA from A1 and Cities from B1 .. A list containing "New York","Washington DC" & "Las Vegas" appears in C1.
3) If I choose Canada from A1 and States from B1 .. A list containing "Ontario","Quebec" & "Alberta" appears in C1.
4) If I choose canada from A1 and citiesfrom B1 .. A list containing "Toronto","Victoria" & "Regina" appears in C1.

Is that possible plz ??

Thank u in advance.

 

[Akashwani]

Hi,

Take a look here and see if there is any helpful videos/information....

excelisfun -- Excel How To Videos - YouTube

Drop Down Lists | Get Digital Help

I hope that helps.

Ak

 

[Tornado1981]

Nice and helpfull videos .. but i couldn't find an answer to my problem there.
Any help please ?

 

[Marcelo Branco]

Another link
Excel Data Validation -- Dependent Lists

M.

 

[Aladin Akyurek]

Source in B1:

=INDIRECT(A1)

Source in C1:

=INDIRECT(B1)

 

[Tornado1981]

the problem is not in the direct function .. the problem is that there will be states assigned to USA and others to Canada
i mean how i could differentiate between USA states and Canada states and the same for cities

 

[Aladin Akyurek]

hi,

Can anyboby plz help me solving this problem ?
I have 3 cells (A1,B1 & C1)
In A1 I have a data validation list named "AAA" and containing "USA" & "Canada"
In B1, a data validation list named "BBB" and containing "States" & "Cities"

What I want to do is that:
1) If I choose USA from A1 and States from B1 .. A list containing "Texas","California" & "Illinois" appears in C1.
2) If I choose USA from A1 and Cities from B1 .. A list containing "New York","Washington DC" & "Las Vegas" appears in C1.
3) If I choose Canada from A1 and States from B1 .. A list containing "Ontario","Quebec" & "Alberta" appears in C1.
4) If I choose canada from A1 and citiesfrom B1 .. A list containing "Toronto","Victoria" & "Regina" appears in C1.

Is that possible plz ??

Thank u in advance.

the problem is not in the direct function .. the problem is that there will be states assigned to USA and others to Canada
i mean how i could differentiate between USA states and Canada states and the same for cities

Create the following in A:F on a sheet called DVLists...

AAA	BBB	USAstates	USAcities	CANADAstates	CANADAcities
USA	States	Texas	New York	Toronto	Toronto
CANADA	Cities	California	Washington DC	Quebec	Victoria
		Illinois	Las Vegas	Alberta	Regina

<colgroup><col style="width: 48pt;" span="2" width="64"> <col style="width: 68pt; mso-width-source: userset; mso-width-alt: 3242;" width="91"> <col style="width: 97pt; mso-width-source: userset; mso-width-alt: 4579;" width="129"> <col style="width: 85pt; mso-width-source: userset; mso-width-alt: 4039;" width="114"> <col style="width: 75pt; mso-width-source: userset; mso-width-alt: 3555;" width="100"> <tbody>
</tbody>

Name on DVLists...

A2:A3 as AAA
B2:B3 as BBB
C2:C4 as USAstates
D2:D4 as USAcities
E2:E4 as CANADAstates
F2:F4 as CANADAcities

On Sheet1, create in:

DV list in A1 with as Source: AAA
DV list in B1 with as Source: BBB
DV list in C1 with as Source:

=INDIRECT(A1&B1)

 

[Tornado1981]

thank u so much

 

[Aladin Akyurek]

thank u so much

You are welcome. Thanks for providing feedback.