Variable Lookups and Validation Problem - XL2003

[Ivan Howard]

Hi all,

I have one spreadsheet that contains a template where people from different countries will be filling out.

At the top of the template - I have a selection box (created with a Data Validation List from the "Data" menu) used to select a country.

In the template, and in a column that will be filled out, I have another data validation list that needs to change depending on the selected counrty. I have 'tables' (ranges) in the spreadsheet that contain the different country information that I need to pull through into the validation lists - depending on what country is selected.

Someone has said something about the INDIRECT formula.. but I need some help.

Any help would really be appreciated!

Ivan

 

[Aladin Akyurek]

See:

http://www.mrexcel.com/board2/viewtopic.php?p=154

 

[Ivan Howard]

Thanks very much Aladin - this has worked exactly how I wanted it to!!!

Take care

Ivan