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