Get instant live Excel expert help to learn how to add data validation in excel

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

Hi, I need to extend the width of a data validation menu so I can see very long text that is larger than the column of the data validation. I want the column to have 8 width but the excel pull down menu to have 25 width
Solved by O. B. in 15 mins
Good afternoon I have reworded below for you In date sheet I type in a drivers rego in row S then row R and Row T vlookup looks at row S and uses drivers sheet and added the name and phone number I would like so when I type in a rego and 2 drivers have the same rego a data validation shows up so I can pick which which driver should be listed with there phone number if you need to take longer time I am more then willing to pay for 2/3 sessions fixing this problem I have will greatly help
Solved by O. W. in 22 mins
Good afternoon I have reworded below for you In date sheet I type in a drivers rego in row S then row R and Row T vlookup looks at row S and uses drivers sheet and added the name and phone number I would like so when I type in a rego and 2 drivers have the same rego a data validation shows up so I can pick which which driver should be listed with there phone number any help with this problem would be great thanks
Solved by C. H. in 20 mins
Looking to have a formula create an output based upon a dynamic dropdown. This is the formula, but I can't get it to work or repeat throughout the column. (Have tried Data Validation work, but no go!)
Solved by S. H. in 14 mins
I have created a data Validation drop down list out of a list of companies. I would like to know if I can use VLOOKUP to auto populate a list based on the selection of a previous list
Solved by C. E. in 25 mins
Yesterday I was working on a project involving drop down menu excel and I wanted to pick a company name from that drop down, then based on the company chosen, I want the company address to appear in a cell below and the phone number to appear in the cell below the address, can you help? Basically If the company I pick from the drop down menu is Company A then Company A's mailing address will generate in the cell below the drop down cell and Company A's phone number will generate in the cell below the address. I have gotten the drop down to list all the companies using Data Validation but every Function I use after to transfer the correct address based on the company chosen will not work. The only way it works is if it brings over numeric data but I want text.
Solved by B. F. in 18 mins
Hello- I have file with three dependent data validation dropdowns (you select a medical specialty, and based on that you select a subspecialty, and based on that you select a medical condition/keyword). I also have a macro in place so that if someone reselects a different medical specialty, the dependent dropdowns automatically erase. This form is submitted with a submit button that generates an email. I have found that a user has saved off a copy of the form and was then able to type over the "condition/keyword" box that should be protected. Is there a way to control that if someone saves a copy of the form?
Solved by I. J. in 24 mins
Hi, I'm trying to set up excel data validation from table column, and want it to be dynamic so that if the rows increase the validation applies. I named the range, then set the data validation to =countif(namerange,c2)<=1. I see the validation in every cell, but it allows me to enter a duplicate. what am I doing wrong?
Solved by V. J. in 18 mins
I was just on with someone, tried the fix on my spreadsheet about data validation table excel, and it does not work, need to connect again
Solved by B. S. in 16 mins
I am in need of Excel Validation being used twice on the same cell.
Solved by M. Q. in 12 mins