Data Validation

Copper Contributor

Hello

I am looking for help on a  case where on one sheet you have 3 data types

1)SR.No

2) Name

3) Status .

 

On the 2nd sheet there is a data validation list type where you can only get a list with status as "open" besides the name.

 

Thanks in advance

1 Reply

@LuciferBV 

Attached is a file with various data validation examples.

You can adapt the respective examples according to your needs.

 

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.