Two Data Validations in a Single Cell

[hrayani]

Hi,

I need to apply two data validations in a single cell. One is the name and other is a text

1) =validation_customers (This one is a named range)
2) ALL (This one is a simple Text)

I would like to know how to apply these two in a single cell.

Any help would be appreciated.

Regards,

Humayun

 

[Eric W]

If you want it to show as a drop-down list, you'll need to add ALL to your validation_customers range. If you want the user to type the name manually, you can use this custom DV formula:

=OR(ISNUMBER(MATCH(H1,validation_customers,0)),H1="all")

where H1 is the cell it's in.

 

[hrayani]

Hi Eric,

Thanks for the reply.

Its not working.... getting a msg (The list source must be delimited list, or a reference to a single row or column)

Any idea ??

Thanks

 

[Eric W]

When setting up the DV rule, did you set the Allow: parameter to Custom?

 

[hrayani]

oh... i was trying in the List Option

Now working perfect

Thanks

 

[Eric W]

You're welcome.