Dropdown Query
in [Functions]
|
From: Dharmesh on 17 May 2010 00:27 Dear all, I have two columns. Each column contains a defined value and each > value carries some predefined details. I am trying to place a dropdown > through data validation, so that i select any value, i should be getting all > the details related to that value without any extended space. Like below-: > > > A operations > A downtime > a client figure > B ratings > B flow chart > B technical support > > If i select A, I want to get the details of A as dropdown, i select B, i > want to get the details of B. > I have also visited Debra Dalgleish site http://www.contextures.com/xlDataVal13.html But, my concern was unanswered. Can it be done via OFFSET function or by any other function,please suggest me. I would be highly grateful to you ! Regards Dharmesh
From: ozgrid.com on 17 May 2010 02:14 See http://www.ozgrid.com/Excel/dependent-lists.htm and download 2 demo files. -- Regards Dave Hawley www.ozgrid.com "Dharmesh" <Dharmesh(a)discussions.microsoft.com> wrote in message news:090DEBD6-1466-49E8-ABF7-844D3DA88C7F(a)microsoft.com... > Dear all, I have two columns. Each column contains a defined value and > each >> value carries some predefined details. I am trying to place a dropdown >> through data validation, so that i select any value, i should be getting >> all >> the details related to that value without any extended space. Like >> below-: >> >> >> A operations >> A downtime >> a client figure >> B ratings >> B flow chart >> B technical support >> >> If i select A, I want to get the details of A as dropdown, i select B, i >> want to get the details of B. >> > I have also visited Debra Dalgleish site > > http://www.contextures.com/xlDataVal13.html > > But, my concern was unanswered. > > > Can it be done via OFFSET function or by any other function,please suggest > me. > > I would be highly grateful to you ! > > Regards > Dharmesh >
|
Pages: 1 Prev: Fixing a formula to read a general format? Next: Pivot from multiple sheets |