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)

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)

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)

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)

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)