Forum Discussion
Data validation with multiple columns
Hello all I work for a medical centre in australia and do all the ordering, I use an excel spreadsheet to enter all the data but it is very time consuming, I want to use data validation from a dr...
I assume that you have a list of products with their prices. It works best if this list is a table (Insert tab of the ribbon > Table to convert a range to a table):
On the sheet where you want to enter the products you order, you can use data validation of type list with the first column of the table as source.
Again, this works best in a table. You can use XLOOKUP (or in older versions, VLOOKUP) to retrieve the price for a selected product.
See the attached sample workbook.
Thank you very helpful
