populating neighbouring columns based on drop-down choice
in [Programming]
|
From: mikeg on 3 May 2010 01:46 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.
From: ozgrid.com on 3 May 2010 02:06 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" <mikegower(a)gmail.com> wrote in message news:369b9396-8bf8-4758-81de-e0fb3f6f45f7(a)k29g2000yqh.googlegroups.com... >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.
|
Pages: 1 Prev: VBA and VB.NET give different results for same RegEx code Next: copy range |