Combo boxes and linked ranges

  • Thread starter Thread starter tedc
  • Start date Start date
T

tedc

I have created a spread sheet for printing and storing dog show
information
I have created a combo box to call up the various show venues from a
named range.
Is it possible to somehow link the 'secretary', 'address etc' columns
to appear in the appropriate postions as indicted on the screen shot


Ted Cullen


[image: http://www.users.bigpond.net.au/reviver/excel.jpg]
 
Hi

Yes, it's is. Use VLOOKUP function for it.
With additional information in adjacent columns to show venues list (from
where you defined the named range for venues):
Define additional named range p.e. ShowTable, including columns Venue,
Secretary, Address, etc.
On report sheet, let's show venue be displayed in cell p.e. C3.
Secretary=VLOOKUP(C3,ShowTable,2,FALSE)
Address=VLOOKUP(C3,ShowTable,3,FALSE)
etc.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

linking a form combo box... results from the combo box to another 1
Combo Box 2
Combo Boxes - linking of 5
combo box printing 1
link few combo box 2
Changing input range of a combo box crashes Excel 2
Locating an Excel combo box range 3
Active x combo box and linking 1

Back
Top