Way to use Vlookup function in Data Validation : Restrict users to allow values from the lookup table using Data validation formula box in Excel. Write us at Articles:ĭata Validation in Excel : Data Validation is a tool used to restrict users to input value manually in cell or worksheet in Excel. We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. And also you can follow us on Twitter and Facebook. If you liked our blogs, share it with your friends on Facebook. Find more articles on Date & Time functions here. Hope this article about Way to Use Lookup formula in Data Validation in Excel is explanatory.
Now here the formula is used for the C4 cell. Here we have punctuation in the E4:E10 array and to check is C4 cell. So below is the formula to use in the data validation tool. Here we will apply data validation on the cell to restrict the user to input any value which has punctuation. So, let's test this formula via running it on the example shown below.
#A RANGE CHECK IS A DATA VALIDATION CHECK THAT ____ HOW TO#
How to use Lookup formula in Data Validation?