Excel Forum

Excel Magic Trick 548: Data Validation Drop-Down List In A Cell Same Sheet or Different Sheet

See how to:
1)Add drop down by typing values in
2)Add drop down by selecting range on worksheet
3)Add drop down by naming range on different worksheet
4)Add a warning message
5)Check to see if data is valid
6)VLOOKUP function
7)Name a range
8)Check the list of Names
Add Data Validation Drop-Down List To Cell List on Worksheet or Different Worksheet

Got a Question? Ask it Here in the Forum.