Hi,
I would like to add a validation list to a cell in case an other cell has a specific value.
Let's say A1='myvalue' then A2 should have a validatin list from a named range that called "Mylist", else it should be "no list available"
How could I do it?
Thank you
select A2 go to data validation then select list and type formula
=if(A1="myvalue",mylist,"")
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks