Cell reference using INDIRECT?
 

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

Cell reference using INDIRECT?
 

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.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jumbo Jock" wrote in message
...
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

Cell reference using INDIRECT?
 

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.

"Jumbo Jock" wrote in message
...
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