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:
WithINDIRECTO
fetchinginformationfromtherespectiveTag=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.