Aug 10 2021 01:18 AM - edited Aug 10 2021 01:21 AM
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
Aug 10 2021 03:23 AM
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.