question related to Data Vaildation

  • Thread starter Thread starter Dharmesh
  • Start date Start date
D

Dharmesh

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 !
 
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+L>>Settings>>Allow>>List>>Source>> 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!
 
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
 
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+L>>Settings>>Allow>>List>>Source>> 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!
 
Back
Top