Sir, without selecting the predefined values, it returns emty cell. I entered
value A, but the details of A value -:

operations
downtime
client figure

are missing in Column E. Similarly, If i choose B, I cannot find the details
of B as dropdown. I want to use dropdown in both the columns, so that i may
be able to select A or B as dropdowns and their details in the adjacent
column depending on the selection. Can it be done via OFFSET function or by
any other function,please suggest me.

I would be highly grateful to you !

Regards
Dharmesh


"Ms-Exl-Learner" wrote:

Assume that you are having the defind A value in B Column and defind B value
in C Column and D1 is the Input cell or Dropdown of A & B value. If you want
to get the values of Defined Name A Or B In Column E then Select the E Column
and press Alt+D+LSettingsAllowListSource copy and paste the below
formula.
=INDIRECT($D$1)
Give Ok.

Now change the D1 cell to A Or B and check the E Column Dropdown.

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Dharmesh" wrote:

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
downtime
client figure
B ratings
flow chart
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.

Kindly help !