HOW TO CREATE CUSTOM DROP DOWN LIST | FORMULA IN DATA VALIDATION
A very warm welcome to all my viewers in EXCEL4LEARN Channel. Today in this video I cover how to use formula in data validation and we create a custom drop down list.
What is Data Validation?
Data validation is a process that ensures the delivery of clean and clear data to the programs, applications using it. It checks for the integrity and validity of data that is being inputted to different software and its components. Data validation ensures that the data complies with the requirements and quality benchmarks.
How to use Data Validation in Excel - custom validation rules and formulas?
Select one or more cells to validate.
Open the Data Validation dialog box. For this, click the Data Validation button on the Data tab, in the Data Tools group or press the key sequence Alt - D - L (each key is to be pressed separately).
On the Settings tab of the Data Validation dialog window, select Custom in the Allow box, and enter your data validation formula in the Formula box.
Click OK.
FORMULA:- =IF(LEN($J$4)=3,$E$2:$E$5,IF(LEN($J$4)=4,$F$2:$F$5,$G$2:$G$10))
#EXCEL4LEARN
YouTube Playlist URL:-
• MS-Excel Tutorial by Akshay
LIKE,SUPPORT and SHARE
PLease press SUBSCRIBE Button and hit the bell icon for notification.
LIke my FB Page:- / excel4learn
Instagram Id:- akshay_d13
Google + :- https://plus.google.com/b/10259595250...
LinkedIn: / akshay-dey-028101138
#custom_drop_down_list #data_validation #formula in excel