I've got a list of items that I want to include in a Drop Down. Using data validation, all I need to do is add the range and this works. However, the list has various types of data and I want to create a Data Validation that gives options from the given range if the type is correct. Is this possible?
I've added a link to the list. Essentially, let's say for Life providers, I want to have data validation showing all items in the first column IF their type is Life.