Combo boxes and linked ranges

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]
 
A

Arvi Laanemets

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.
 
Top