 In this training video we're going to look at using data validation and data validation lists. So we want to enter product information in column A and purchase information with the customer in column F. So we've got the information about our customers and then in column B of the products and customers worksheet and we've got information on the products in column A on the same worksheet. So we're going to try and then use this information to produce two separate lists, one for products and one for purchaser. So to do this I'm going to highlight in this case just the data range from E to 321. If this is a huge spreadsheet where the information is going to go on and on you can highlight the whole column but in this example I'm just going to highlight this particular range. So in the data tab we can use a feature called data validation and under the settings we can use a list. There's all kinds of options. When you use a list it says where's your source data. So our source data is on the product and customers worksheet. So in this example I want to use the products and I can put an error message in so if anyone inserts a wrong product that doesn't choose in a list I can say product must be chosen from list. So I'll stop them and I'll just say input error, product must be selected from list. Okay now just test it. So I can start entering products now. So I could say baseball's first product, come down choose another one. So we can see what it's doing. If I type in a product doesn't exist let's say tennis nets you can only choose from the list. So it's stopping you entering data which is not valid. So this is that that's why they call it data validation. So anything that's not valid it won't allow. So I can cancel that and then just repeat the process for the next one. So I'm going to hide at the area that I'll apply the validation to, data tab, the validation, data validation, settings, list in this example. Sources coming from products and customers then selected the list. I'm going to stop for input error. Customer must be selected and list and just test one or two of them. Just leave a couple of blank rows. Now if I typed in one that didn't exist I could say Confold and it says no that doesn't exist. So again it's a way of validating all your information for your customers, your products. So only the correct information can be selected. I'm going to cancel this example and this completes the training video on data validation. In this example data validation lists using lists of information where we got from a separate worksheet in this particular example. But this completes the training video on data validation lists. If you enjoyed this video make sure you like and subscribe to our channel. Hope to see you for the next tutorial and thanks for watching.