Cell reference using INDIRECT?

J

Jumbo Jock

Hi folks,
Need a spot of expert help!
I have a workbook containing several worksheets. On the first worksheet in
cell D3, I have a drop down menu containing country names. Depending on which
country is selected, I would like data to automatically populate in column B
of this worksheet starting at B17. The problem is that the each country's
data is on a separate worksheet and does not necessarily start at the same
cell reference on each worksheet. I have tried with nested IF statements and
the INDIRECT formula but I am getting nowhere. Any ideas on a smart way to
get this done?
Thanks
 
D

Don Guillett

If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples.
 
P

Patrick Molloy

take a look at indirect validation :
http://www.xl-expert.com/IndirectValidation.htm

this uses a dropdown list - each item of the list is actually a named range,
eg Country
the second validation uses =INDIRECT() pointing at the selected item. In
this case, Country would return the countries in that table.

This question has been asked a number of times in the past month - so a
search would be useful to you.
 

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

Top