Data validation

Question

Data validation

Asked 6 years, 2 months ago

Viewed 98 times

3

I am creating a database file and I have a data validation where the model matches its brand.

I did a list type data validation from the table:

With the following formula::

=SE(F6=$Q$5;$Q$6:$Q$8;SE(F6=$R$5;$R$6:$R$7;SE(F6=$S$5;$S$6:$S$7)))

It is working correctly, if you select Tag -> Citröen I can only select in Model -> DS3 or C3 and the same for all other brands.

The question is, is there a simpler way to create data validation? It is necessary to cover almost all brands which will lead to an extensive formula in data validation.

Thank you.

I found a smaller and simpler formula to create the drop-down list (I took @Rbz’s suggestion)

Solution:

With INDIRECTO to fetch information from the respective Mark=Tab makes the "creation" of the drop-down list easier and practical.

Whenever there’s a new Brand we’ll have a new Flap and just put the respective models in the column To the dropdown list is automatically updated.

Note: This solution fits my project.

It depends a lot on how much you have of variations, how many registrations, etc. You might have to reach the level of having 1 tab per brand, with templates, versions, and use the PROCV.

– rbz

2018/09/12 at 10:19
@Rbz, using PROCV won’t indicate only the first value found? But I took your idea of a tab tag and I think the INDIRECTO with help columns can solve my "problem".

– R.Galamba

2018/09/12 at 10:52
Take a look at this link.

– rbz

2018/09/12 at 11:07
That’s not what I mean. What I want is for you to fill out the customer form and indicate the make of the car just let me select the respective models. I got what was expected using: Tabs=Brands and within each Brand your models and used the INDIRECTO and it seems to be working.

– R.Galamba

2018/09/12 at 11:57
How can I post the file to see what I wanted and how I solved it?

– R.Galamba

2018/09/12 at 12:01
However you see fit, but who reads can understand, simulate, execute what you pass.

– rbz

2018/09/12 at 12:26
I edited the question and put the solution. Thank you for the availability.

– R.Galamba

2018/09/12 at 13:41
There are as many characters as a checklist can have. If this occurs, saw this answer

– danieltakeshi

2018/09/12 at 17:20

Show 3 more comments

1 answer

Browser other questions tagged excel

You are not signed in. Login or sign up in order to post.

by Phill • **402** points · Answer 1 · 2018-09-12T13:09:29+00:00

You have a few options, you can use Macros to create a coherent and efficient database, but it will take time to develop and test, but it is the best and best maintenance when the Database is larger.

The second option is to create a drop-down list to have the options of brands and any other column as Template Year version, you can read the tutorial in the MS link itself Suspended List, I find it easier for you to better understand the options

The third one you can also use the PROCV Function, you create an area with the data and you can perform a search for any category you have created as a model, brand, year and etc. you can read the tutorial on Funcao PROCV, also of MS.

Now go on your part analyze which option is best, just remembering in the scalability of the solution, because it is one thing to have a database of 10 cars other is 10,000 cars.