Usage of Data Validation with If Condition
 

I am using Data validation in a sheet, that is working well as per my
requirement.

Now I want to use this with IF Condition.

Mean if a cell has some particular value then Data Validation should work
otherwise it shows blank value on the same column where I have applied data
validation (LIST)

Usage of Data Validation with If Condition
 

Hi, I have the same problem and i need a solution very urgently!
Thanks!

"Mujeeb ur Rehman, FBL-GRW-PK" wrote:

I am using Data validation in a sheet, that is working well as per my
requirement.

Now I want to use this with IF Condition.

Mean if a cell has some particular value then Data Validation should work
otherwise it shows blank value on the same column where I have applied data
validation (LIST)

Usage of Data Validation with If Condition
 

Hi,

Assume that when there is "try" (without double quotes) in cell C6, then a
validation list should appear in cell D6. Elsewhere on the worksheet, enter
the validation list entries, say in C12:C15. Select C12:C15 and assign it a
name, try (the entry in cell C6). Now in cell D6, go to Data Validation
List and enter =indirect(C6) OK

The validation list entries would appear in cell D6 only when there is try
in cell C6, else the validation drop down will show blanks.

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Mujeeb ur Rehman, FBL-GRW-PK"
m wrote in message
...
I am using Data validation in a sheet, that is working well as per my
requirement.

Now I want to use this with IF Condition.

Mean if a cell has some particular value then Data Validation should work
otherwise it shows blank value on the same column where I have applied
data
validation (LIST)

Usage of Data Validation with If Condition
 

Upon your suggession I did the same. One think could not be understand. That
there is no usage of the NAME of the range (C12:C15) which we have assigned.
WHY?

"Ashish Mathur" wrote:

Hi,

Assume that when there is "try" (without double quotes) in cell C6, then a
validation list should appear in cell D6. Elsewhere on the worksheet, enter
the validation list entries, say in C12:C15. Select C12:C15 and assign it a
name, try (the entry in cell C6). Now in cell D6, go to Data Validation
List and enter =indirect(C6) OK

The validation list entries would appear in cell D6 only when there is try
in cell C6, else the validation drop down will show blanks.

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Mujeeb ur Rehman, FBL-GRW-PK"
m wrote in message
...
I am using Data validation in a sheet, that is working well as per my
requirement.

Now I want to use this with IF Condition.

Mean if a cell has some particular value then Data Validation should work
otherwise it shows blank value on the same column where I have applied
data
validation (LIST)

Usage of Data Validation with If Condition
 

Hi,

There is. The entry in cell C6 I.e. try is used to name the contents of
range C12:C15. By doing so, indirect(C6) becomes indirect(try) and try in
turn holds the data in range C12:C15

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Mujeeb ur Rehman, FBL-GRW-PK"
m wrote in message
...
Upon your suggession I did the same. One think could not be understand.
That
there is no usage of the NAME of the range (C12:C15) which we have
assigned.
WHY?

"Ashish Mathur" wrote:

Hi,

Assume that when there is "try" (without double quotes) in cell C6, then
a
validation list should appear in cell D6. Elsewhere on the worksheet,
enter
the validation list entries, say in C12:C15. Select C12:C15 and assign
it a
name, try (the entry in cell C6). Now in cell D6, go to Data
Validation
List and enter =indirect(C6) OK

The validation list entries would appear in cell D6 only when there is
try
in cell C6, else the validation drop down will show blanks.

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Mujeeb ur Rehman, FBL-GRW-PK"
m wrote in message
...
I am using Data validation in a sheet, that is working well as per my
requirement.

Now I want to use this with IF Condition.

Mean if a cell has some particular value then Data Validation should
work
otherwise it shows blank value on the same column where I have applied
data
validation (LIST)