Taking The (USA, France...etc) cascading combo boxes further

KentKHI

KentKHI

Active Member
Joined
Oct 1, 2004
Messages
492
I would like to see if any one can tell me how to set this up to work so it will automatically display the cities population. I tried to use VLOOKUP, but I didn't know what to put in for "table array" value, because it is dependant on what city is in the C column. I am not sure if there is some way to use the indirect formula in that column or what?

Here is what I'm trying to do:
undotest.xls
ABCDEFGH
2
3CountryCityPop.
4USAPittsburgh
5
6
7Database
8countriescitiespopulation
9USAParis1234
10FranceNice4321
11Toulon1212
12
13
14Pittsburgh543
15LA2345
16Boston5432
17
18
Sheet2



Thanks,

Kent
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
Sort by date Sort by votes
Re: Taking The (USA, France...etc) cascading combo boxes fur

Change the definition of FRANCE to:

Sheet2!$E$9:$G$11

That of USA to:

Sheet2!$E$14:$G$16

Use in C4, the data validation cell:

=INDEX(INDIRECT(A4),0,1)

instead of:

=INDIRECT(A4)

In G4 enter in order to retrieve the population of the city, selected in C4...

=VLOOKUP(C4,INDIRECT(A4),3,0)
 
Upvote 0
Re: Taking The (USA, France...etc) cascading combo boxes fur

Aladin,

I used your first idea and it works great! I haven't tried the table array idea so I'm not sure how that works yet.

Its amazing what excel can do,

Kent
 
Upvote 0
You must log in or register to reply here.

Similar threads

K
  • Solved
VBA in User Form. Xlookup formula for Dependent Combo Box.
Replies
8
Views
432
Kscoof
K
T
  • Question Question
VLOOKUP + INDIRECT overlap (maybe not possible)
Replies
5
Views
426
TXNCPO
T
D
  • Question Question
Choose from List Box
Replies
5
Views
243
ddnron
D
E
  • Solved
Display Lookup table from dropdown list in a form?
Replies
3
Views
373
myall_blues
myall_blues
J
  • Question Question
VBA & Combo Box (Form Control) Lock
Replies
3
Views
774
Jaafar Tribak
Jaafar Tribak

Forum statistics

Threads
1,225,364
Messages
6,184,534
Members
453,239
Latest member
dbenthu

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top