Excel validation with if
Closed
fekish
-
Oct 9, 2010 at 12:02 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Oct 12, 2010 at 10:11 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Oct 12, 2010 at 10:11 AM
Hello, i want some help in excel:
I have column A - Brands (about 10 different)
In Column B - types of products of the brands (200 different)
In cilumn C - price of products.
Is there a way to have a data validation in another tab:
Choose in A1: Brand (ok this is straight forward)
Then depending what i chose in A1, to have in B1, only the types of product for that brand as a drop down list?
Thanks!
I have column A - Brands (about 10 different)
In Column B - types of products of the brands (200 different)
In cilumn C - price of products.
Is there a way to have a data validation in another tab:
Choose in A1: Brand (ok this is straight forward)
Then depending what i chose in A1, to have in B1, only the types of product for that brand as a drop down list?
Thanks!
Related:
- Excel validation with if
- Excel mod apk for pc - Download - Spreadsheets
- Number to words in excel - Guide
- Display two columns in data validation list but return only one - Guide
- Gif in excel - Guide
- Kernel for excel - Download - Backup and recovery
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Oct 12, 2010 at 10:11 AM
Oct 12, 2010 at 10:11 AM
Hi Fekish,
I solved this matter on another query, take a look:
https://ccm.net/forum/affich-479817-dependent-cells-with-data-validation#p479860
Let me know if you get stuck.
Best regards,
Trowa
I solved this matter on another query, take a look:
https://ccm.net/forum/affich-479817-dependent-cells-with-data-validation#p479860
Let me know if you get stuck.
Best regards,
Trowa
