See http://www.ozgrid.com/Excel/dependent-lists.htm and download 2 demo
files.



--
Regards
Dave Hawley
www.ozgrid.com
"Dharmesh" wrote in message
...
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