Data Validation

3

I am creating a database file and have a data validation where the template matches the respective tag.

I'vedoneadatatypevalidationlistfromthetable:

Withthefollowingformula:

  

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

Isworkingproperly,ifyouselectMark->CropIcanonlyselectintheModel->DS3orC3andthesameforallotherbrands.

Thequestionis:isthereasimplerwaytocreatedatavalidation?Itisnecessarytocoveralmostallbrandswhichwillleadtoanextensiveformulaindatavalidation.

Thankyou.

Ifoundasmaller,simplerformulatocreatethedrop-downlist(Ipickedup@rbz'ssuggestion)

Solution:

WithINDIRECTOfetchinginformationfromtherespectiveTag=Tabmakesthe"creation" of the drop-down list easier and more practical.

Whenever there is a new Brand we'll have a new Aba and just put their templates in the A column .

Note: This solution is for my project.

    
asked by anonymous 12.09.2018 / 11:05

1 answer

0

You have a few options, you can use Macros to create a coherent and efficient Database, but it will take a while to develop and test, but it's the best and best in maintenance when you grow the Database.

The second option is to create a drop-down list to have the tag options and any other column like Model 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 you can also use the PROCV function, you create an area with the data and can perform a search for any category you have created such as template, brand, year and so on. you can read the tutorial at PROCV function , also from MS.

Now it's up to you to analyze which option is best, just remembering the scalability of the solution, because one thing is to have a database of 10 cars and another is 10,000 cars.

    
12.09.2018 / 15:09