Excel, Validation, VLOOKUP
Posted on 2015-01-14
Using Data Validation to prevent invalid data from being entered into a cell. Validation criteria is to allow only data from a List.
Values for the list are contained in a separate worksheet in the same workbook. Is it possible to create a list of valid items using VLOOKUP?
VLOOKUP looks for a value in the leftmost column of a table, and then returns a value in the same row from a column that I specify. It doesn't produce a list.