populating neighbouring columns based on drop-down choice
 

I have a worksheet which contains a column listing types of issues.
Another column lists examples of each of these issues. (e.g., "ALT
incorrect" is the issue and "ALT missing", "ALT should be empty", and
"ALT not accurate" are all examples)
The other worksheets all are testing results tracking these issues by
webpage. The issue column on each of these worksheets is populated as
a dropdown based on a Defined Name from the first worksheet's issues
column via a Validated Data List.
I would like to construct a neighbouring column on each of these
worksheets so that when I choose an issue from the first column, the
next column on that row is populated with the correct examples.
I know this must be dead easy, but can't figure out. Thanks for
assistance.

populating neighbouring columns based on drop-down choice
 

Try VLOOKUP or INDEX/MATCH
http://www.ozgrid.com/Excel/excel-vlookup-formula.htm
http://www.ozgrid.com/Excel/left-lookup.htm



--
Regards
Dave Hawley
www.ozgrid.com
"mikeg" wrote in message
...
I have a worksheet which contains a column listing types of issues.
Another column lists examples of each of these issues. (e.g., "ALT
incorrect" is the issue and "ALT missing", "ALT should be empty", and
"ALT not accurate" are all examples)
The other worksheets all are testing results tracking these issues by
webpage. The issue column on each of these worksheets is populated as
a dropdown based on a Defined Name from the first worksheet's issues
column via a Validated Data List.
I would like to construct a neighbouring column on each of these
worksheets so that when I choose an issue from the first column, the
next column on that row is populated with the correct examples.
I know this must be dead easy, but can't figure out. Thanks for
assistance.