Excel validation with if

Closed
fekish - Oct 9, 2010 at 12:02 PM
TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 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!

1 reply

TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 541
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
0