question related to Data Vaildation
 

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 !

question related to Data Vaildation
 

Fist select the data and set the defined for that. For example: select the
below data and press Cntrl+F3 and name it as A.

operations
downtime
client figure

Like that select the ranges and name it. Assume that D1 is the Input cell
or Dropdown (A & B). If you want
to get the data 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 in message
...
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 !