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

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
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

T
  • Question Question
VLOOKUP + INDIRECT overlap (maybe not possible)
Replies
5
Views
419
TXNCPO
T
E
  • Solved
Display Lookup table from dropdown list in a form?
Replies
3
Views
291
myall_blues
myall_blues
J
  • Question Question
VBA & Combo Box (Form Control) Lock
Replies
3
Views
587
Jaafar Tribak
Jaafar Tribak
M
  • Solved
Selective Match/Vlookup (?) on Various Criteria in Single Row
Replies
2
Views
256
m3ko
M
P
  • Question Question
Matching an ID from 2 columns in 2 worksheets to then produce the figure from a 3rd column.
Replies
4
Views
296
Pavesib
P

Forum statistics

Threads
1,222,691
Messages
6,167,670
Members
452,131
Latest member
MichelleH77

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