• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Data validation to restrict cell value from a certain value.

T

topbink

New Member
Here is what I'm trying to do. I have a list of banned items, and if I type this item name into a cell it will pops a warning that the item is invalid. So still I can type any value in that cell but those in the banned list.

Is it possible doing that by using data validation? And if there is any other solution would be great also... :)
 
Hi ,


Certainly you can use Data Validation ; select Custom , and type in the following formula :


=ISERROR(MATCH(data_entry_cell,Banned_list,0))


where data_entry_cell is the cell where you will enter data ; this is also the cell which should have this Data Validation formula. Banned_List is the range where the banned items are listed.


Narayan
 
Solved ... Solved .... Solved ...

@narayank911: You're a life saver. It works perfectly. Thank you so much.
 
You must log in or register to reply here.
Back
Top