Hi,

I have two cells with dropdowns in them - cells A2 and B2. In A2 I used the
data validation to only allow my salespeople to be selected and now I want to
make a validation in cell B2 that will only allow the products that my
salesperson is allowed to sell.

I have a table that lists all of the salespeople multiple times in one
column and then the product that they can sell listed in the next column
(each on its own row). For example:

Mike Balls
Mike Racquets
Mike Strings
Frank Strings
Frank Wristbands
etc.

Is it possible for the data validation in cell B1 to look into cell A1 and
then look into the table to find which products the salesperson is allowed?

Any help is greatly appreciated.

Thanks,
Michael